On 26 March 2010 21:43, Lasse Bunk <[email protected]> wrote: > Jonathan, > > You could use "Eastern Time (US & Canada)" as your timezone? Like this: > > config.time_zone = 'Eastern Time (US & Canada)' > > Would this do the trick?
No, because it expects the times in the db to be in UTC and will convert them (wrongly) to EST on reading and writing. Colin > /Lasse > > 2010/3/26 J Graham <[email protected]> >> >> Hello, >> >> I've Googled and searched for this for many hours now and couldn't >> find an answer although I did find a lot about timezones and rails. >> >> Specifically I'm attaching a basic Rails CRUD frontend onto a legacy >> database. The datetime fields in the database are stored as Eastern >> Standard Time. There is a lot of legacy code that uses this database >> and is expecting to get back times in EST, so I can't change them to >> UTC. >> >> Is there a way in Rails to tell ActiveRecord to use Eastern for >> storing the datetime fields? >> >> I've tried a number of combinations for config.time_zone and >> config.active_record.default_timezone. FYI, rake time:zones:local >> returns * UTC -06:00 * Central Time (US & Canada). >> >> Any ideas would be greatly appreciated. >> >> Thanks, >> -Jonathan >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby on Rails: Talk" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/rubyonrails-talk?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

