Jumbo Posted July 10, 2019 Share Posted July 10, 2019 (edited) Hey Larry - Great book, appreciate your thoroughness, will read your other PHP books. I'm stuck in Chapter 5, using the SQL.sql download file to insert pages into MySQL. I keep receiving error 1292 regarding the "NOW()+100000" portion of the query. Below, "NOW()+100000" resolves to an integer, but is it merely unformatted? ERROR 1292 (22007): Incorrect datetime value: '20190710504258' for column 'date_created' at row 2 Edited July 10, 2019 by Jumbo Link to comment Share on other sites More sharing options...
Jumbo Posted July 10, 2019 Author Share Posted July 10, 2019 Regret asking this question, but if anyone wants the answer, I had to use now() in a context that would render an acceptable value. For me this was in combination with interval: (NOW() + INTERVAL 1 DAY)) .. etc. Converted seconds (?) to days. Link to comment Share on other sites More sharing options...
Larry Posted July 11, 2019 Share Posted July 11, 2019 Hmmm...this is the kind of thing that may change in different versions of MySQL. Nice work switching to using the + INTERVAL syntax, though! Link to comment Share on other sites More sharing options...
Recommended Posts