projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9c9f0f2) | 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)
committerBill Erickson <berickxx@gmail.com>
Thu, 21 Mar 2019 19:46:23 +0000 (15:46 -0400)
commitf3ff1f470fe97077ec5859412c1d5ae701da1e7e
treecedaaebb6c4de733b4a0c7f4928644aedb905964tree
parent9c9f0f2a5497ae4f4e13c5d008e6e4e1c6758b43commit | 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/upgrade/XXXX.schema.dob-as-date.sql [new file with mode: 0644] blob
Evergreen ILS