I'm storing datetime values in UTC for an international site. Then retrieving the data using 'select convert_tz(created, 'GMT','MST') from table_name', so that the datatime appears in the correct local datetime for the user. Does this method take into account daylight savings? If not, how can this be achieved? or perhaps I'm barking up the completely wrong tree!

Thanks,
Steve


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to