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

date posted 11th May 2008 18:00

Thanks Dave.

Vicki

Dave Cross wrote:
>
> 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...
>