Help, Australian Time Problem
Is there a faq on this..cause boy it is giving me a headache.
System is FreeBSD 4.9
System date returns Tue Nov 25 16:32:36 EST 2003
Postgres Version is 7.3.4 installed from the port collection
I've set the datestyle to ISO, european
I've set australian_timezones to true
I've set TimeZone to local
I do a SELECT CURRENT_TIMESTAMP as today; or SELECT now();
and I get
2003-11-25 05:36:18.17298+00
which is 11 hours behind, how do I get it to report the correct time?
Dean
Dean Grubb <dean@atrium-online.com.au> writes:
I've set TimeZone to local
That will certainly not work - TimeZone needs to be set to a string that
your system will recognize as a specific time zone. (Unfortunately, a
bogus setting gets treated as "UTC" on most platforms, which in fact is
what you're seeing.)
I dunno what the standard BSD names are for the Aussie timezones; can
anyone help? On HPUX you'd use something like 'EST-10EDT' but I'm not
sure about BSD...
regards, tom lane