| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | d ravipati <devrpp(at)rediffmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Database server time zone |
| Date: | 2003-01-16 15:09:44 |
| Message-ID: | 20030116150944.GB24326@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Jan 16, 2003 at 10:58:24 -0000,
d ravipati <devrpp(at)rediffmail(dot)com> wrote:
> Hi,
> Is there any command to find database server local time zone
> alone.
>
> SHOW TIME ZONE just displays database servers local time zone.
> But I need to hold output of SHOW TIME ZONE in a variable, to
> convert the input given in GMT to database server time zone.
> Is there any other way to get database server time zone?
> Thanks
> Devi
If the input timestamp includes a timezone specification indicating GMT,
you shouldn't have to do anything. If the timestamp is a string without
timezone information, you should be able to manipulate the string to
indicate that it is GMT.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jtrumbo | 2003-01-16 15:56:48 | database monitoring tool availability |
| Previous Message | Sharanayya G M | 2003-01-16 13:13:02 |