Re: Setting time zone commands

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cnliou(at)so-net(dot)net(dot)tw
Cc: "" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Setting time zone commands
Date: 2003-12-03 04:52:02
Message-ID: 27038.1070427122@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"cnliou" <cnliou(at)so-net(dot)net(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Olleg 2003-12-03 07:57:05 Conflicts with autoconf macroses
Previous Message cnliou 2003-12-03 03:41:33 Re: Setting time zone commands