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