]> granicus.if.org Git - postgresql/commit
Make EXTRACT(TIMEZONE) and SET/SHOW TIMEZONE follow the SQL convention
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 17 Jul 2003 00:55:37 +0000 (00:55 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 17 Jul 2003 00:55:37 +0000 (00:55 +0000)
commit764f72dc823edb3f8bdf387501ce4c12dedd2369
tree01838a17f094eb1ac2a0f99102002adbff063605
parent93236b58e088cd2151540528d484da9ad82e48c8
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.
doc/src/sgml/func.sgml
doc/src/sgml/ref/set.sgml
doc/src/sgml/release.sgml
src/backend/commands/variable.c
src/backend/utils/adt/date.c
src/backend/utils/adt/nabstime.c
src/backend/utils/adt/timestamp.c
src/include/miscadmin.h
src/include/utils/datetime.h
src/interfaces/ecpg/pgtypeslib/dt.h