Re: timezone_hour missing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kari Lempiainen <kari(at)funky(dot)pp(dot)fi>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: timezone_hour missing
Date: 2003-03-04 23:02:55
Message-ID: 10689.1046818975@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kari Lempiainen <kari(at)funky(dot)pp(dot)fi> writes:
> temperature=# select extract(timezone_hour from timestamp '2001-10-10
> 01:04:54.965162+03');
> ERROR: TIMESTAMP units 'timezone_hour' not supported

"timestamp" doesn't contain a timezone. Use "timestamp with time zone".

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-03-04 23:05:07 Re: password method in pg_hba.conf fails
Previous Message Tom Lane 2003-03-04 22:52:15 Re: pg_ctl -m fast failing?