Re: [HACKERS] extract(timezone_hour) funny business

2001-10-10 Thread Thomas Lockhart
> Plus or minus? Is there a standard for this? We are printing date/time using Posix conventions, which are opposite from the SQL conventions for setting time zone (which we don't yet support, since it is fundamentally useless ;) I apparently implemented one, and you expect the other. > peter=#

[HACKERS] extract(timezone_hour) funny business

2001-10-10 Thread Peter Eisentraut
peter=# select current_timestamp; timestamptz --- 2001-10-10 01:04:54.965162+02 (1 row) peter=# select extract(timezone_hour from current_timestamp); date_part --- -2 (1 row) Plus or minus? peter=# select extract(timezone_hour from timesta