Re: FN-FORUM: Getting GMT with MySQL NOW()

date posted 11th May 2008 18:00

It works a treat. Thanks Owen.

Vicki

Owen Smith wrote:
> This might work (dst date differences allowing)
>
> SELECT DATE_ADD(NOW(), INTERVAL 2 HOUR);
>
> which will give you an EST date result. For a result in PST, you would do:
>
> SELECT DATE_SUB(NOW(), INTERVAL 1 HOUR);
>
> If you are working with time in seconds instead of dates, then factor in the
> offset in seconds. Because there are 3600 seconds in an hour, and EST is 2
> hours later than MST, the following converts timestamps from MST to EST:
>
> SELECT unix_timestamp() + (3600 * 2);
>
> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP() + (3600 * 2));
>
> Cheers
>
> Owen
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Vicki
> Sivess
> Sent: 11 May 2008 18:44
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: Getting GMT with MySQL NOW()
>
>
> Does anyone know how the MySQL NOW() function can be made to use GMT
> instead of the server time? A site I am doing some work on has just been
> moved onto a server in America. The environment varaible has been set in
> PHP (putenv("TZ=Europe/London");) but in the SQL queries NOW() is
> returning East coast of America time.
>
> According to the manual, we need to set the system time zone for the
> MySQL Server at startup. It gives two options: one is to set it with the
> --timezone=timezone_name option to mysqld_safe.
>
> The guy who is running the server doesn't seem very sure about this, and
> anyway as it is not a dedicated server, I don't know if he will be able
> to run the mysql demon.
>
> Does anyone know of another (simpler) way of doing this?
>
> Thanks,
>
> Vicki
>
>
>