MySQL Forums
Forum List  »  Oracle

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Current Date Needed on Import
7600
Joe Bongiovi
December 13, 2004 02:58PM
Re: Current Date Needed on Import
2526
Joe Bongiovi
December 13, 2004 03:44PM
Re: Current Date Needed on Import
3446
Josh Chamas
December 15, 2004 03:20AM
Re: Current Date Needed on Import
2498
Anders Karlsson
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.