Re: [Rails] Date formats

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 <simon@2ndquadrant.com> wrote:
> On Tue, Oct 25, 2011 at 5:52 PM, Tom Allison <tom@tacocat.net> 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 rubyonrails-talk@googlegroups.com.
> To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
> 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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.