Postgres Pro
Downloads
Home   >   mailing lists

Re: timezone_hour missing - Mailing list pgsql-general

From Tom Lane
Subject Re: timezone_hour missing
Date
Msg-id 10689.1046818975@sss.pgh.pa.us
Whole thread Raw
In response to timezone_hour missing  (Kari Lempiainen <kari@funky.pp.fi>)
List pgsql-general
Tree view 
Kari Lempiainen <kari@funky.pp.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: password method in pg_hba.conf fails
Next
From: Tom Lane
Date:
Subject: Re: bug ? updates and insert crash the backend