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: 20020131203327.A6485@zombie.antar.bryansk.ru (view raw or flat)
Thread:
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;
> SET VARIABLE
> 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

Responses

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-2014 The PostgreSQL Global Development Group