MySQL - ER_TRUNCATED_WRONG_VALUE: Invalid date and time value in Timestamp column

I have a MYSQL column that is defined as TIMESTAMP.

Whenever I create a string with javascript the new Date()

value is saved without error.

However, when I want to update the value by posting the same one new Date()

to this column, I get the error

Error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '2017-06-16T17:35:34.377Z' for column 'last_access'.

      

I can manipulate everything like Datetime and format the date accordingly to resolve the error, however I want to understand why the error is occurring.

+3


source to share





All Articles