My apologies, what I said in this previous post is incorrect.
It appeared as if the time was UTC (except for daylight savings)
to me, but it was mearly because of the format string
As Paul DuBois quite rightly pointed out is that %h in
select FROM_UNIXTIME(UNIX_TIMESTAMP(),
'%Y %D %M %h:%i:%s %x');
returns the hour in 12hour format, I assumed it was in
24hour format which makes it appear close to UTC in
my timezone.
Thus select FROM_UNIXTIME(UNIX_TIMESTAMP(),
'%Y %D %M %h:%i:%s %x');
does not return GMT time but local time.
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
>Convert this to a date format and you have a GMT date.
>
>Thanks to Chris Land for pointing the UNIX_TIMESTAMP() function
>out to me.
>
>The only prob is daylight savings. We in NSW, Australia are currently
>in daylight savings and the date returned doesn't accomodate for that.
>Any one have any ideas why?
>
>[mysql]
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
<[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
