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