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
No one has answered this question yet
Check out similar questions: