You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
During the DST to standard time change, when the SQL server is running in a local time zone, records cannot be found when expires_at is set to 1 hour.
Given a PST time and a fallback to standard time at 2 AM, 1 hour from 1 AM, is going to be still 1 AM. The date s converted to the same date that was entered and few seconds after the record cannot be found again.
The expires_at column should be timezone agnostic, possible solution would be to store it as an integer (epoch time),
The text was updated successfully, but these errors were encountered:
Context
During the DST to standard time change, when the SQL server is running in a local time zone, records cannot be found when
expires_at
is set to 1 hour.Given a PST time and a fallback to standard time at 2 AM, 1 hour from 1 AM, is going to be still 1 AM. The date s converted to the same date that was entered and few seconds after the record cannot be found again.
The
expires_at
column should be timezone agnostic, possible solution would be to store it as an integer (epoch time),The text was updated successfully, but these errors were encountered: