[GENERAL] date_part('timezone_hour')

[Jukka Väänänen]

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



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])