I was wondering if anyone had any tricks on the best way to handle localizing time zones in MySql?
For example, all my datetime data is stored as GMT. I have written tools to query the data based upon whatever local time zone you want to use. So, for example if I query for 2003-10-1 to 2003-10-2 in EDT, it would really query 2003-9-30 20:00:00 to 2003-10-1 20:00:00. BUT, I've run into a problem when you want to GROUP BY DAYOFYEAR(datefield) for example, I want it to do the grouping by EDT and not GMT -- is this possible? Regards, Graeme -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]