Re:Storing UTC is not a silver bullet (2019)
by ivan_gammel on Sunday March 13, 2022 @07:28AM
(#30660301)
No, this is not a display rule. This is the domain data type "local time", which stores time component without offset or time zone.
Data stored this way is basically telling that regardless of current UTC offset, locally on the clock there will be always the same time shown.
Display rules are saying how exactly this time will be displayed on the clock (i.e. locale, 12/24 hour format etc). Wall clocks usually do not show "am/pm" information, so the same time indeed may occur twice on them.
Re:Storing UTC is not a silver bullet (2019)
by progval on Sunday March 13, 2022 @09:35AM
(#30661074)
"wall-clock time" does not mean what is shown by a literal wall clock. It means the time used by people who are not computer engineers. https://en.wikipedia.org/wiki/Elapsed_real_time
When the parent comment said "Wall clock times may occur twice", they meant between 2 and 3am when when leaving DST.
We don't typically care about this because we work 9-5 M-F, and daylight savings time conveniently happens at 2am on Sunday morning. But someone was told to come in at 2am this morning and couldn't actually do that because 1:59:59 became 3:00:00. How do you handle that? It's not a code problem, it's a business rules problem.