That wouldn't work because for example: GMT day for 2003-10-13 = '2003-10-13' EDT day for 2003-10-13 = GMT '2003-10-12 20:00:00 -> 2003-10-13 20:00:00'
I want the GROUP BY (adjusted to EDT) to show 2003-10-13, but it shows 2003-10-12.... know what I mean? I don't know how to work around this... Regards, Graeme | On 10 Oct 2003 at 14:12, Graeme B. Davis wrote: | | > 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? | | You say you've already got the necessary time zone offsets, right? | So can you use "SELECT DAYOFYEAR( datefield - INTERVAL 4 HOUR ) AS | day ... GROUP BY day"? | | -- | Keith C. Ivey <[EMAIL PROTECTED]> | Tobacco Documents Online | http://tobaccodocuments.org | | | -- | MySQL General Mailing List | For list archives: http://lists.mysql.com/mysql | To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]