e.
At 02:13 PM 5/02/2002 +1100, Oliver Mannion wrote:
>I am close to a solution:
>
>select FROM_UNIXTIME(UNIX_TIMESTAMP(),
> '%Y %D %M %h:%i:%s %x');
>
>
>UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00'
GMT
>
in standard time right now. In Arizona, they don't do
>daylight savings at all.
>
>james montebello
>
>On Tue, 5 Feb 2002, Oliver Mannion wrote:
>
>> I am close to a solution:
>>
>> select FROM_UNIXTIME(UNIX_TIMESTAMP(),
>> '%
I am close to a solution:
select FROM_UNIXTIME(UNIX_TIMESTAMP(),
'%Y %D %M %h:%i:%s %x');
UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00' GMT
Convert this to a date format and you have a GMT date.
Thanks to Chris Land for pointing the UNIX_TIMEST
Hi dn,
Right. Having said that tho, is there a function
in mysql that will return the GMT time from the operating
system, that I can subsequently use in a query.
I could use the GMT time from the db client but I
would prefer to use the GMT time from the operating
system mySQL is running on.
Than
Hi,
I would like to obtain the time in GMT in mySQL.
CURRENT_TIMESTAMP returns the local time
SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on
my system
But how can I get the time in GMT???
Thanks for your time,
Oliver
