Posted by ojorus on 09/26/06 14:38

Hi!
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...

Any suggestions?

greetings
ojorus

[Back to original message]