Make EXTRACT(TIMEZONE) and SET/SHOW TIMEZONE follow the SQL convention
Tom Lane <tgl@sss.pgh.pa.us>
Make EXTRACT(TIMEZONE) and SET/SHOW TIMEZONE follow the SQL convention for the sign of timezone offsets, ie, positive is east from UTC. These were previously out of step with other operations that accept or show timezones, such as I/O of timestamptz values.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +4 −4 |
| doc/src/sgml/ref/set.sgml | modified | +5 −5 |
| doc/src/sgml/release.sgml | modified | +3 −1 |
| src/backend/commands/variable.c | modified | +8 −5 |
| src/backend/utils/adt/date.c | modified | +7 −6 |
| src/backend/utils/adt/nabstime.c | modified | +9 −7 |
| src/backend/utils/adt/timestamp.c | modified | +7 −6 |
| src/include/miscadmin.h | modified | +4 −2 |
| src/include/utils/datetime.h | modified | +14 −3 |
| src/interfaces/ecpg/pgtypeslib/dt.h | modified | +13 −2 |