Postgres Pro
Downloads
Home   >   mailing lists

Version 8.2.6 - ecpg: current_timestamp - how to control timezone - Mailing list pgsql-general

From paul tilles
Subject Version 8.2.6 - ecpg: current_timestamp - how to control timezone
Date
Msg-id 486A6E21.8080404@noaa.gov
Whole thread Raw
Responses Re: Version 8.2.6 - ecpg: current_timestamp - how to control timezone
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: SAST FATAL: could not access private key file "server.key"
Next
From: Tom Lane
Date:
Subject: Re: Version 8.2.6 - ecpg: current_timestamp - how to control timezone