Version 8.2.6 - ecpg: current_timestamp - how to control timezone

From: paul tilles <Paul(dot)Tilles(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: Version 8.2.6 - ecpg: current_timestamp - how to control timezone
Date: 2008-07-01 17:49:21
Message-ID: 486A6E21.8080404@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-07-01 19:55:49 Re: Version 8.2.6 - ecpg: current_timestamp - how to control timezone
Previous Message Albe Laurenz 2008-07-01 15:52:28 Re: SAST FATAL: could not access private key file "server.key"