]> granicus.if.org Git - postgresql/commit
Add 'day' field to INTERVAL so 1 day interval can be distinguished from
authorBruce Momjian <bruce@momjian.us>
Wed, 20 Jul 2005 16:42:32 +0000 (16:42 +0000)
committerBruce Momjian <bruce@momjian.us>
Wed, 20 Jul 2005 16:42:32 +0000 (16:42 +0000)
commitdb05f4a7eb6c80c67c25ca9d28be825b99ed3553
treedee67dee9058a0243609c838c6be521143d23f3b
parent826604f9e61c233c4229a3eb4d1ee3945691ee1b
Add 'day' field to INTERVAL so 1 day interval can be distinguished from
24 hours. This is very helpful for daylight savings time:

select '2005-05-03 00:00:00 EST'::timestamp with time zone + '24 hours';
      ?column?
----------------------
2005-05-04 01:00:00-04

select '2005-05-03 00:00:00 EST'::timestamp with time zone + '1 day';
      ?column?
----------------------
2005-05-04 01:00:00-04

Michael Glaesemann
12 files changed:
doc/src/sgml/func.sgml
src/backend/commands/variable.c
src/backend/utils/adt/date.c
src/backend/utils/adt/formatting.c
src/backend/utils/adt/nabstime.c
src/backend/utils/adt/selfuncs.c
src/backend/utils/adt/timestamp.c
src/include/catalog/pg_proc.h
src/include/catalog/pg_type.h
src/include/utils/timestamp.h
src/interfaces/ecpg/pgtypeslib/interval.c
src/test/regress/expected/interval.out