Kari Lempiainen wrote:
> temperature=# select version();
> version
> ---------------------------------------------------------------------
> PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
> (1 row)
>
> Time: 1,91 ms
> temperature=# select extract(timezone_hour from timestamp '2001-10-10
> 01:04:54.965162+03');
> ERROR: TIMESTAMP units 'timezone_hour' not supported
Try:
template1=# select extract(timezone_hour from timestamp with time zone
'2001-10-10 01:04:54.965162+03');
date_part
-----------
-4
(1 row)
--
Olleg Samoylov