Amusing MySQL date error -
04-09-2011
, 01:26 PM
I got the message
(1292, "Incorrect datetime value: '2011-03-13 02:18:28' for column
'first_seen' at row 1")
This is because that hour doesn't exist if MySQL is working with
local times. That's the skipped hour during which daylight savings
time started.
It's good that MySQL catches this. I had to do a
SET time_zone="+00:00";
to set the connection to UTC.
John Nagle |