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