| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | Jeff Boes <jboes(at)qtm(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Timezone conversion |
| Date: | 2003-02-14 21:08:42 |
| Message-ID: | 10901.1045256922@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> On Thu, 13 Feb 2003, Jeff Boes wrote:
>> Is there a straightforward way to change the display of a time to another
>> timezone? For example, my server's environment is EST (-0500); I want to
>> convert timestamps for display in PST (-0800).
> I think you might be able to use "AT TIME ZONE" to do what you want. I
> think it's described in Chapter 6 of the user's guide.
Also, there's always the straightforward approach: temporarily change
the TIMEZONE variable ;-)
I believe AT TIME ZONE is new in 7.3.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2003-02-14 21:31:41 | Re: postmaster -i & establishes three connections why? |
| Previous Message | Eduardo | 2003-02-14 20:57:44 | Re: PL/PGSQL EDITOR |