Thank you very much. I had a feeling it was a postgres thing and not a rails thing. I'm impressed at what rails/ruby can do about timezone just the same.
Personally, I find working with date/time to be the most problematic data type *ever*! On Wed, Oct 26, 2011 at 4:16 AM, Simon Riggs <[email protected]> wrote: > On Tue, Oct 25, 2011 at 5:52 PM, Tom Allison <[email protected]> wrote: >> Just realized I have a nice problem. >> >> using Postgresql... >> >> When I save something via Rails to the table it's saved with a GMT >> offset (so 12:00 becomes 16:00) >> But the database is configured to save everything as GMT. >> >> Which means -- when I query it via SQL it's coming back as now + 4 >> hours instead of just plain now. >> >> Where/How do I get this back in sync? > > In SQL Standard you set a client timezone using SET TIME ZONE, which > PostgreSQL supports. > > Timezone can be set using the "timezone" configuration parameter, > which can be set in the file postgresql.conf, or in any of the other > standard ways described, such as set for each session using SET. There > are also some special ways to set it: > > * The SQL command SET TIME ZONE sets the time zone for the session. > > * The PGTZ environment variable is used by libpq clients to send a > SET TIME ZONE command to the server upon connection. > > So you can set this on the client or the server, for the user, > explicitly and other ways. > > -- > Simon Riggs http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services > > -- > 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.
