Re: now() and time zone - Mailing list pgsql-general

Jean-Christophe Roux <jcxxr@yahoo.com> writes:
> I am a bit sorry to come back on that topic but I just cannot get it right. How comes that
>     select now() at time zone 'EST'
> returns
>     "2006-10-04 15:59:26.713623"
> when it is actually 16:59 on the east coast?

USA east coast is currently on EDT ... not EST.

In PG 8.1 and later you can say AT TIME ZONE 'EST5EDT' or
AT TIME ZONE 'America/New_York' to get the behavior I think you are
after.

            regards, tom lane