Re: Select current_timestamp as a different timezone..

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Williams, Travis L, NPONS" <tlw(at)att(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Select current_timestamp as a different timezone..
Date: 2003-04-22 23:23:26
Message-ID: 3EA5CEEE.4020000@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Williams, Travis L, NPONS 2003-04-22 23:25:23 Re: Select current_timestamp as a different timezone..
Previous Message Joe Conway 2003-04-22 23:20:19 Re: can you select on an OID?