projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 85c19f2) | patch
LP#1818912: normalize time by truncating to second granularity user/miker/lp-1818912-emergency-closing-due-date-push-fails
authorMike Rylander <mrylander@gmail.com>
Mon, 23 Mar 2020 14:36:48 +0000 (10:36 -0400)
committerMike Rylander <mrylander@gmail.com>
Tue, 24 Mar 2020 15:14:11 +0000 (11:14 -0400)
commit3272baf1fd431ae5a10dd634366a8de0095210f8
treeea8b61d65d9af6baa1342ec4d4fa184e6f3438e4tree
parent85c19f2d20b4154801ba6127e4b33d3a02178925commit | diff
LP#1818912: normalize time by truncating to second granularity

When the emergency closing handler goes to grab the list of circulations
and holds it should work on, it can miss some due to sub-second
components of the closing start/end timestamps.  This commit introduces
a function for truncating timestamps to second-granularity, and then
uses that function when looking for in-range objects.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/000.functions.general.sql diff | blob | history
Open-ILS/src/sql/Pg/096.schema.emergency_closing.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.function.emergency_closing_time_normalization.sql [new file with mode: 0644] blob
Evergreen ILS