MySQL Forums
Forum List  »  Oracle

Re: Current Date Needed on Import
Posted by: Josh Chamas
Date: December 15, 2004 03:20AM

Joe Bongiovi wrote:
> Found the solution to my problem. By defining the
> column as type TIMESTAMP, it's value will default
> to the current date and time during an import, as
> long as you are not attempting to associate any
> value from your input file to that TIMESTAMP
> column.

You got it. Note however that when a row is updated, a timestamp column will also update its date, so make sure this is OK.



Josh Chamas
Director, Professional Services
MySQL Inc.,
Get More with MySQL!

Options: ReplyQuote

Written By
December 13, 2004 02:58PM
December 13, 2004 03:44PM
Re: Current Date Needed on Import
December 15, 2004 03:20AM
December 17, 2004 03:05AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.