search

fastmail / Ix

automatic generation of JMAP-style APIs
GNU General Public License v2.0
10 stars 5 forks source link

Standardize on 'timestamptz' for date / time fields #49

Closed wolfsage closed 7 years ago

wolfsage commented 7 years ago

We want to store times with timezone information. This is useful incase something writes data to the DB in other timezones than UTC - when retrieved, the data will still be correct.

Require Ix users to specify 'timestamptz' instead of 'datetime' since SQL::Translator takes 'datetime' to mean 'timestamp without timezone'.

rjbs commented 7 years ago

Looks good to me. I leave it to you to merge this since it has downstream including a db update. (We can talk about sorting out ongoing schema updates after the holidays.)