Does anyone know any way to be able to group by day/week/month for an adjusted date (GMT -> EDT).
I store dates as GMT in the db, but sometimes I want to count the number of rows per EDT day instead of GMT day. I can't figure out how to do this. Ideas? Thanks, Graeme ----- Original Message ----- From: "Graeme B. Davis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 10, 2003 2:12 PM Subject: Converting GMT stored data into other zones | 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] | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
