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
