Re: [HACKERS] Time zone questions
> australia=# select '2002-03-18 00:00:00' at time zone 'Australia/Sydney'; > ERROR: Time zone 'australia/sydney' not recognized > australia=# set time zone 'Australia/Sydney'; > SET VARIABLE > australia=# select '2002-03-18 00:00:00'; > ?column? > - > 2002-03-18 00:00:
[HACKERS] Time zone questions
I need to do some timezone manipulation, and I was wondering about this difference: australia=# select version(); version -- PostgreSQL 7.1.3 on i386--freebsd4.4, compiled by GCC 2.95.3 (1 row) australia=# sel