On Mon, May 18, 2009 at 11:16 AM, Bayless Kirtley <bkirt@xxxxxxx> wrote: > ----- Original Message ----- From: "John R Pierce" <pierce@xxxxxxxxxxxx> >> Bayless Kirtley wrote: >>> >>> How can I tell PostgreSQL to use daylight saving time when applicable? >>> Times returned by the database are one hour behind. >> >> it uses your client's specified local time zone to determine whether or >> not DST is in effect. >> >> SET TIME ZONE 'America/New York'; >> >> or >> >> SET TIME ZONE 'PST8PDT'; >> >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > For some reason I can't seem to make it work. I have tried setting the > timezone > in postgresql.conf as "timezone = 'America/Chicago'" and "timezone = > 'CST6CDT'" > both of which still returned one hour behind. I also tried both of your > suggestions > as SQL statements right after establishing a database connection and still > get the > same wrong time. It's not about what's set in postgresql.conf, it's what the client timezone is. If you connect from your client and issue "show timezone;" what do you get? > I have a Java application on Windows XP PRO and the way I am getting the > time is "Select CURRENT_TIME". Is there something I am missing or is there > another way I should be getting the time? Nope, sounds right. Again, what's the client application think the timezone is? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
