Right. Perl seems to work with daylight savings, how is this?
At 08:03 PM 4/02/2002 -0800, James Montebello wrote: > >UTC doesn't do daylight savings. One reason is that different places >do daylight savings at different times. We here in the Western US, for >example, are 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(), >> '%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