Re: Version 8.2.6 - ecpg: current_timestamp - how to control timezone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: paul tilles <Paul(dot)Tilles(at)noaa(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Version 8.2.6 - ecpg: current_timestamp - how to control timezone
Date: 2008-07-01 19:55:49
Message-ID: 18775.1214942149@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

paul tilles <Paul(dot)Tilles(at)noaa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roberts, Jon 2008-07-01 20:20:24 pg crashing
Previous Message paul tilles 2008-07-01 17:49:21 Version 8.2.6 - ecpg: current_timestamp - how to control timezone