Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- summer time issue in mysql
September 26, 2006, 2:38 pm
rate this thread
A simple question maybe...
I have a datetime column in a table, and want to automaticly insert local
(Norwegian) time into the column. (I use PHP 5) I can not use NOW() since
the mysql server is set up with a different time zone. So now i use
UTC_TIMESTAMP() + INTERVAL 2 HOUR, which give me the right time now. BUT a
problem will occur some time in october, when we end summer time, and Norway
will go back to UTC + 0100.
Of course I could manually go into my PHP code and change the query to ...
UTC_TIMESTAMP() + INTERVAL 1 HOUR ..., but I was hoping there was some
easier way to to this. (I don't want to change my code twice a year...).
One solution is of course to tell my PHP code when summer time starts and
ends for the next say ten years, and then vary the INTERVAL number from 1 to
2 or the other way. But still I was hoping there was some easier ways...