MySQL Forums
Forum List  »  MySQL Workbench

MYSQL TIMESTAMP error code 1292 when loading table from file.
Posted by: Pete Watters
Date: February 09, 2018 02:41PM

I have a table with a column "date_created" where I have tried type as both DATETIME and TIMESTAMP.

I set the default for this filed to CURRENT_TIMESTAMP

I have a cvs file from which I want to load data into the table where the value of the column date_created is blank.

When I load the file into the table I get an error code 1292 Incorrect Datetime Value

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL TIMESTAMP error code 1292 when loading table from file.
270
February 09, 2018 02:41PM


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.