Open sde1000 opened 2 years ago
Timestamps for events that have already happened should be stored as timestamp with time zone.
timestamp with time zone
Fields affected:
Session.starttime
Session.endtime
UserToken.last_seen
Payment.time
Transline.time
StockTake.create_time
StockTake.start_time
StockTake.commit_time
Stock.onsale
Stock.finished
StockAnnotation.time
StockOut.time
LogEntry.time
RefusalsLog.time
There are no future events currently allowed for in the schema, so there are no DateTime quantities that should be in localtime.
Timestamps for events that have already happened should be stored as
timestamp with time zone.Fields affected:
Session.starttimeSession.endtimeUserToken.last_seenPayment.timeTransline.timeStockTake.create_timeStockTake.start_timeStockTake.commit_timeStock.onsaleStock.finishedStockAnnotation.timeStockOut.timeLogEntry.timeRefusalsLog.timeThere are no future events currently allowed for in the schema, so there are no DateTime quantities that should be in localtime.