summer time issue in mysql

[ojorus]

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

[ZeldorBlat]

ojorus wrote:

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

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.

[ojorus]

"ZeldorBlat" <ze********@gmail.comskrev i melding
news:11**********************@i3g2000cwc.googlegro ups.com...

>
ojorus wrote:

>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

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.

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

ojorus