Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > On Thu, Apr 24, 2008 at 06:30:27PM +1200, Steve Martin wrote: >> => show timezone ; >> TimeZone >> ------------- >> NZST-12NZDT >> (1 row)
> I have no idea what timezone that it. Presumably it switches between > daylight savings and non-daylight savings based on the US rules? Yeah, that's a POSIX zone spec. See http://www.postgresql.org/docs/8.3/static/datatype-datetime.html#DATATYPE-TIMEZONES As noted there, if the OP really really wants to spell his zone name that way, he could fool with the "posixrules" file in the timezone database. But Pacific/Auckland is probably better. (I don't remember whether 8.1 would honor changes in "posixrules".) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
