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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
