hi,
using postgresql 7.3.1:
# select current_timestamp,date_part('timezone_hour',curren t_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
ma*******@postgresql.org)