Timezone problem

Rails
1

Okay I have a database with all timestamps stored in
GMT, but each customer (who’s timezone is known),
wants all data and query done in their timezone. So
presentation is the standard offset and where clauses
subtracts the offset.

Could this be done as an extension to active record
such that all queries automatically adjust dates to
the timezone of the customer?

Shawn

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

2

Hi Shawn,

while it’s not an AR extension the ruby tzinfo library is your best
bet imho -

http://tzinfo.rubyforge.org/

Regards,
Trevor

On 10-Feb-06, at 2:14 PM, Shawn G. wrote:

Shawn

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Rails mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails

–
Trevor S.
http://somethinglearned.com