I was getting this error message.
Incorrect datetime value: ‘2015-03-29 01:40:44’
After a lot of head scratching and googling. It a timezone issue I believe.
I ran this command before trying the insert and this solved it.
SET @@time_zone := '+00:00'
After this the insert worked perfectly.
With thanks to Dean Trower who posted this fix on the MariaDB page for timestamps. I have to admit I was banging my head against the wall on this one as my timezone is GMT…
Leave a Reply