MySQL Forums
Forum List  »  Newbie

Re: datetime load error
Posted by: Diego Medina
Date: November 16, 2007 11:09AM

if you convert your timestamp and datetime columns to char(255),
then load your data (I tested dates in this format 2007-11-10 15:56:44 AM)

then change them back to timestamp or datetime. I get warnings that data was truncated but that is because the AM is not there any more, but the data is properly converted.

Diego Medina
Web Developer
http://www.fmpwizard.com

P.S. Please read this post if you are going to post code

Options: ReplyQuote


Subject
Written By
Posted
November 16, 2007 09:35AM
Re: datetime load error
November 16, 2007 11:09AM
November 16, 2007 11:59AM
November 16, 2007 02:59PM
November 19, 2007 07:50AM


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.