Back
Query on Datetime attribute by server time
Is there a way to query database documents by the server time (e.g. "now()")? Querying by the client time (e.g. Datetime.now()) seems a bit unreliable and is not useable where the current time really matters, like expiration dates.
TL;DR
Developers are discussing the best practice for saving datetimes in the database. They are debating whether to save datetimes in UTC or convert local time to UTC before saving. There is a query about how to retrieve database documents by the server time (e.g. "now()") rather than the client time (e.g. Datetime.now()) for cases where current time accuracy is crucial.
No. Although you proxy through a Function?
Should you save datetimes in your DB as UTC and convert local time to UTC?
