Using Perl: my $GMTdate = gmtime(time);
this will give you the GMT time. >>On Tue, 05 Feb 2002 15:27:18 +1100, Oliver Mannion <[EMAIL PROTECTED]> wrote: >>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] Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= --------------------------------------------------------------------- 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