Re: [GENERAL] Version 8.2.6 - ecpg: current_timestamp - how to control timezone

2008-07-01 Thread Tom Lane
paul tilles <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

[GENERAL] Version 8.2.6 - ecpg: current_timestamp - how to control timezone

2008-07-01 Thread paul tilles
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 curr