or maybe I'm being at idiot and didn't realize we are currently in
DST!!!..
Travis
-----Original Message-----
From: Williams, Travis L, NPONS
Sent: Tuesday, April 22, 2003 6:39 PM
To: Williams, Travis L, NPONS; Joe Conway
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Select current_timestamp as a different timezone..
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly