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...
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 "
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
