As the title suggests, i'm unable to insert this timestamp specificly into the database. The date is valid, why doesn't it insert? The error I'm getting is:
Warning: #1299 Invalid TIMESTAMP value in column
Asked
Active
Viewed 517 times
-1
PaaPs
- 373
- 1
- 4
- 18
-
And your code is where? – juergen d Aug 24 '18 at 06:14
-
it's just an sql statement. have 100's of rows and other timestamp values insert, but this one specificly does not. The code is valid, the timestamp is not and I'm trying to find out why it is not valid. – PaaPs Aug 24 '18 at 06:15
-
What data type is your column? – juergen d Aug 24 '18 at 06:16
-
it's `timestamp` – PaaPs Aug 24 '18 at 06:17
-
Not sure how can anyone help you without actually seeing the code. – sskoko Aug 24 '18 at 06:18
-
1http://sqlfiddle.com/#!9/eedc84/1 It should work – juergen d Aug 24 '18 at 06:18
-
**this is not the codes fault**, byt mysql's, because the timestamp `2018-03-25 04:00:00` Does insert fine. – PaaPs Aug 24 '18 at 06:19
-
3Daylight saving time 2018 in Lithuania began at 03:00 on Sunday, 25 March – P.Salmon Aug 24 '18 at 06:25
-
Correct, I'm in Lithuania, and my timestamp is set to this timezone. – PaaPs Aug 24 '18 at 06:29
-
How about you reproduce your error on your system with the code I wrote in the SQLFiddle of my last comment. – juergen d Aug 24 '18 at 06:36
1 Answers
0
It's probably because of the Daylight Savings Time (25th march this year), maybe this can help MySQL datetime fields and daylight savings time -- how do I reference the "extra" hour?
Nogueira Ludovic
- 19
- 2