projects / working / 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)
committerBill Erickson <berickxx@gmail.com>
Wed, 30 Sep 2015 16:49:36 +0000 (12:49 -0400)
commita7fa9e81628711431dcfdf0f6aa82086a7f78e6d
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>
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