This project is archived and is in readonly mode.

#3777 ✓resolved

[PATCH] PostgreSQL timestamp with zone type support

Reported by JackC | January 24th, 2010 @ 02:35 AM

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. With this patch ActiveRecord sets the connection time to UTC when creating the connection if AR::Base.default_timezone is :utc. Rails can then handle time zones its way and other clients can use PostgreSQL's time zone handling.

Comments and changes to this ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

<h2 style="font-size: 14px">Tickets have moved to Github</h2>

The new ticket tracker is available at <a href=""></a>

People watching this ticket

Referenced by