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

date posted 11th May 2008 17:19

Vicki Sivess wrote:
>
> Does anyone know how the MySQL NOW() function can be made to use GMT
> instead of the server time?

It can't without some relatively complex reconfiguration.

You can, however, use the utc_date(), utc_time() and utc_timestamp()
functions instead.

Dave...