The current Rails practice with PostgreSQL is to use timestamp without zone and use ActiveRecord's time zone handling. This works fine for Rails but makes it slightly inconvenient for ad hoc, local time queries outside of Rails. I believe there is a way to get the best of both worlds. If when creating the connection, ActiveRecord set the connection time zone to UTC then Rails could handle time zones its way and other clients could use PostgreSQL's time zone handling.
Is there any interest in a patch to this effect? Jack
-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" 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-core?hl=en.
