Version 8.2.6 - ecpg: current_timestamp - how to control timezone
Started by Paul Tillesalmost 18 years ago2 messagesgeneral
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
Re: Version 8.2.6 - ecpg: current_timestamp - how to control timezone
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