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

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-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT

Section 6.8.3. AT TIME ZONE

HTH,

Joe