]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 8d3544e) | patch
LP#838525 Store date of birth as SQL DATE type
authorBill Erickson <berickxx@gmail.com>
Tue, 29 Sep 2015 16:10:31 +0000 (12:10 -0400)
committerMike Rylander <mrylander@gmail.com>
Thu, 1 Oct 2015 18:47:10 +0000 (14:47 -0400)
commit71592293e1be843e4f478f98c3899e068f699e6b
treed05318bcebc39e2d291d969bec3ab3994bf2a2f3tree
parent8d3544ef37b42aaf4c71d38f0c8cbf6d4d1ca53ecommit | diff
LP#838525 Store date of birth as SQL DATE type

Upgrade script translates DoB ahead 3 hours before translating to DATE
(from TIMESTAMPTZ) to ensure dates stored in alternate daylight savings
TZ (e.g. -05 vs. -04) are translated to the proper date.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/005.schema.actors.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.dob-as-date.sql [new file with mode: 0644] blob
Evergreen ILS