Fix (hopefully for the last time) problems with datetime values displaying
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Oct 2005 17:21:47 +0000 (17:21 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Oct 2005 17:21:47 +0000 (17:21 +0000)
commit4f2bf1c45a4125acdab7946b801b8d3a13270d4e
treed03d6b12339f634cf15c6bcce433d51f53d9b564
parentbe6964d56cb4b638e3900bd1ae19a20be5be26aa
Fix (hopefully for the last time) problems with datetime values displaying
like '23:59:60' because of fractional-second roundoff problems.  Trying
to control this upstream of the actual display code was hopeless; the right
way is to explicitly round fractional seconds in the display code and then
refigure the results if the fraction rounds up to 1.  Per bug #1927.
contrib/btree_gist/btree_ts.c
src/backend/utils/adt/date.c
src/backend/utils/adt/datetime.c
src/backend/utils/adt/timestamp.c
src/include/utils/date.h
src/include/utils/timestamp.h
src/interfaces/ecpg/pgtypeslib/dt.h
src/interfaces/ecpg/pgtypeslib/dt_common.c
src/interfaces/ecpg/pgtypeslib/interval.c
src/interfaces/ecpg/pgtypeslib/timestamp.c