date_part('timezone_hour') - Mailing list pgsql-general

From Jukka Väänänen
Subject date_part('timezone_hour')
Date
Msg-id Pine.LNX.4.44.0309161054070.1960-100000@localhost.localdomain
Whole thread Raw
Responses Re: date_part('timezone_hour')  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
hi,

using postgresql 7.3.1:

# select current_timestamp,date_part('timezone_hour',current_timestamp);
          timestamptz          | date_part
-------------------------------+-----------
 2003-09-16 10:51:58.228489+03 |        -3
(1 row)

I would expect date_part('timezone_hour') to return 3. But it returns -3
instead. Why so?

-Jukka



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: State of Beta 2
Next
From: Gnanakumar Thavamani
Date:
Subject: How to ALTER VARCHAR datatype to TEXT ?