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.

Regards,

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Options: ReplyQuote


Subject
Views
Written By
Posted
7633
December 13, 2004 02:58PM
2544
December 13, 2004 03:44PM
Re: Current Date Needed on Import
3473
December 15, 2004 03:20AM
2519
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.