Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting time zone commands - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Setting time zone commands
Date
Msg-id 27038.1070427122@sss.pgh.pa.us
Whole thread Raw
In response to Re: Setting time zone commands  ("cnliou" <cnliou@so-net.net.tw>)
List pgsql-bugs
Tree view 
"cnliou" <cnliou@so-net.net.tw> writes:
> (2) What is the correct syntax to set time zones having 30
> minutes offset UTC?

"SET TIME ZONE 8.5" works, as does "SET TIME ZONE INTERVAL '08:30';"

            regards, tom lane

pgsql-bugs by date:

Previous
From: "cnliou"
Date:
Subject: Re: Setting time zone commands
Next
From: Olleg
Date:
Subject: Conflicts with autoconf macroses