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]
