Skip site navigation (1) Skip section navigation (2)

Re: Dates and daylight saving time

From: Fduch the Pravking <fduch(at)antar(dot)bryansk(dot)ru>
To: Tom Pfau <T(dot)Pfau(at)emCrit(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Dates and daylight saving time
Date: 2002-01-31 17:33:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On Thu, Jan 31, 2002 at 11:44:53AM -0500, Tom Pfau wrote:
> try 'set timezone to <tzname>' replacing <tzname> with your timezone
> before your query.
> template1=# set timezone to est;
> template1=# SELECT date(date '2001-10-28' + interval '1 day');
>     date
> ------------
>  2001-10-29
> (1 row)

Yes, it works!

But now postgres accepts input and returns output
in GMT, not local time like before! Is it a feature?

Fduch M. Pravking

In response to


pgsql-bugs by date

Next:From: Peter V. CooperDate: 2002-01-31 17:40:58
Subject: Re: New to Postgresql - Backend timeout /JDBC
Previous:From: Marc LavergneDate: 2002-01-31 17:12:19
Subject: array_dims function is poorly behaved

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group