Timezone problem


#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
http://mail.yahoo.com


#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
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails


Trevor S.
http://somethinglearned.com