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?