summer time issue in mysql

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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?


Re: summer time issue in mysql

ojorus wrote:
Quoted text here. Click to load it

In PHP, call date_default_timezone_set() with the appropriate timezone
setting.  Then use date() to format the UTC timestamp you get from
MySQL.  No adding or deleting hours, no summer time, everything will
just take care of itself.

Re: summer time issue in mysql

Quoted text here. Click to load it
Problem is, I have PHP 5.0.4, which does not support  
date_default_timezone_set(), so I have to do it another way.


Site Timeline