Closed Bug 1442008 Opened 8 years ago Closed 8 years ago

Lando should include timestamps when storing dates in the database

Categories

(Conduit :: Lando, enhancement)

enhancement
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: smacleod, Assigned: smacleod)

References

Details

(Keywords: conduit-triaged)

Lando API is storing some of the dates it tracks as "timestamp without time zone" types in the postgres database. We should ensure all the dates are being stored with timezone support (set as UTC). Examples: - landoapi.models.landing:Landing.updated_at (`db.Column(db.DateTime(), nullable=False`) - landoapi.models.landing:Landing.created_at (`db.Column(db.DateTime(), nullable=False`) To get proper timezone support the columns should be using something like: ``` db.Column(db.TIMESTAMP(timezone=True), server_default='NOW()', nullable=False) ``` (server_default is useful for things like created_at timestamps).
Assignee: nobody → smacleod
Status: NEW → RESOLVED
Closed: 8 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.