date_part('timezone_hour')

From: Jukka Väänänen <jukka(dot)vaananen(at)batman(dot)jypoly(dot)fi>
To: pgsql-general(at)postgresql(dot)org
Subject: date_part('timezone_hour')
Date: 2003-09-16 07:59:18
Message-ID: Pine.LNX.4.44.0309161054070.1960-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gnanakumar Thavamani 2003-09-16 09:47:43 How to ALTER VARCHAR datatype to TEXT ?
Previous Message Benoît Costes 2003-09-16 07:35:04 Question.