Improve behavior of date_bin with origin in the future Currently, when the origin is after the input, the result is the timestamp at the end of the bin, rather than the beginning as expected. This puts the result consistently at the beginning of the bin.
Author: John Naylor <[email protected]> Discussion: https://www.postgresql.org/message-id/cafbsxsgjldxqofrfh+d4ksaxxpf3mmevug7s6edfdbovhld...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/496e58bb0e5e939e6ed5839c92b05e3ab11b54bb Modified Files -------------- src/backend/utils/adt/timestamp.c | 14 +++++++++ src/test/regress/expected/timestamp.out | 54 +++++++++++++++++++++++++++++++++ src/test/regress/sql/timestamp.sql | 34 +++++++++++++++++++++ 3 files changed, 102 insertions(+)
