Member Avatar for shammi.khan.73

//In Node/JS
myDate = moment(data.myTime.format('YYYY/MM/DD HH:MM:SS')).toISOString();
//myDate shows '2014-09-24T04:09:00.000Z'

Insert INTO (dateColumn..) Values(myDate)...
This is the error I get after inserting, note column in Mysql is a "datetime" type.

MySQL Error:: { [Error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '2014-09- 24T04:09:00.000Z' for column '_dateColumn' at row 1] code: 'ER_TRUNCATED_WRONG_VALUE',

  • 2 Contributors
  • 1 Reply
  • 1K Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

It happens because MySQL doesn't seem to really support ISO 8601, but the date is parsed and inserted if the server is not in strict mode, it will generate only a warning that looks like this:

show warnings\G
*************************** 1. row ***************************
  Level: Warning
   Code: 1292
Message: Truncated incorrect datetime value: '2014-09-26T00:47:32+02:00'

Docs:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.