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

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