Обсуждение: Version 8.2.6 - ecpg: current_timestamp - how to control timezone

We have noticed that in the ecpg version for postgres 7.4.8, that the
timezone associated with current_timestamp was UTC.   We recently
upgraded to postgres Version 8.2.6 and notice that the timezone
associated with current_timestamp is the local time zone.

How do we set the time zone for current_timestamp to be UTC?

Paul Tilles

paul tilles <Paul.Tilles@noaa.gov> writes:
> How do we set the time zone for current_timestamp to be UTC?

http://www.postgresql.org/docs/8.2/static/datatype-datetime.html#DATATYPE-TIMEZONES

            regards, tom lane