Re: Select current_timestamp as a different timezone.. - Mailing list pgsql-novice

From Williams, Travis L, NPONS
Subject Re: Select current_timestamp as a different timezone..
Date
Msg-id AB815D267EC31A4693CC24D234F8291604549088@ACCLUST02EVS1.ugd.att.com
Whole thread Raw
In response to Select current_timestamp as a different timezone..  ("Williams, Travis L, NPONS" <tlw@att.com>)
List pgsql-novice
Ok.. I have another question about time zones.. Is there a way to tell
if someone who use daylight savings time is currently in daylights
savings time (i.e. If I'm converting time should I convert my time to
EST or EDT?) or am I going to have to manually decide if they are in DST
or not?  Just playing around it doesn't look like postgres looks at
whether they are in dst or not.. it just does the math based on the
table.

Travis

-----Original Message-----
From: Williams, Travis L, NPONS
Sent: Tuesday, April 22, 2003 6:25 PM
To: Joe Conway
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Select current_timestamp as a different timezone..


Thanks.. I was looking in the 7.2 documentation and didn't see.. either
that or I'm blind!!

Travis

-----Original Message-----
From: Joe Conway [mailto:mail@joeconway.com]
Sent: Tuesday, April 22, 2003 6:23 PM
To: Williams, Travis L, NPONS
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Select current_timestamp as a different timezone..


Williams, Travis L, NPONS wrote:
> All, Is there a way to do this?  Take current_timestamp (which on my
> box is CST) and select it as maybe EST?
>

See:
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/functions-da
tetime.html#FUNCTIONS-DATETIME-ZONECONVERT

Section 6.8.3. AT TIME ZONE

HTH,

Joe


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


pgsql-novice by date:

Previous
From: "Williams, Travis L, NPONS"
Date:
Subject: Re: Select current_timestamp as a different timezone..
Next
From: "Williams, Travis L, NPONS"
Date:
Subject: Re: Select current_timestamp as a different timezone..