Re: Time zones and grouping

2003-10-14 Thread Mikhail Entaltsev
t;[EMAIL PROTECTED]> To: "Graeme B. Davis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 14, 2003 2:36 PM Subject: Time zones and grouping > Does anyone know any way to be able to group by day/week/month for an > adjusted date (GMT -> EDT). >

Time zones and grouping

2003-10-14 Thread Graeme B. Davis
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 -