Re: Setting time zone commands

Includem"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>nwrote:
>> So, what is the official syntax?
>
>See the SET command's reference page. I believe you need
to quote
>anything that doesn't look like an identifier or number.

Thank you very much! You have clarified all my timestamp and
time zone questions except the last minor two as follows:

(1) The query using UTC offset hours (SET TIME ZONE '<0 - 23
integers>') to set time zone will be the legal SQL command
for quite a while, won't it?

(2) What is the correct syntax to set time zones having 30
minutes offset UTC?

db1=# set time zone '08:30';
ERROR: unrecognized time zone name: "08:30"
db1=# set time zone 08:30;
ERROR: syntax error at or near ":" at character 17
db1=# set time zone '-03:30';
ERROR: unrecognized time zone name: "-03:30"
db1=# set time zone 'NST';
ERROR: unrecognized time zone name: "NST"

Regards,
CN