Comment

Comment on If a database is edited before daylight savings time ends (time rolls back), would that corrupt the database?

trxxruraxvr@lemmy.world ⁨1⁩ ⁨week⁩ ago

It depends on the database. But it’s common practice to store values in UTC, which doesn’t have DST and only display in the user’s timezone. What you saw was probaby only a but on the front end, but not database corruption.

source

Sort:hotnew top

LastYearsIrritant@sopuli.xyz ⁨1⁩ ⁨week⁩ ago
Or just Unix (epoch) time.

en.wikipedia.org/wiki/Unix_time

There can be problems with leap seconds using UTC (or leap hours eventually)

en.wikipedia.org/wiki/Leap_second

source
- CookieOfFortune@lemmy.world ⁨1⁩ ⁨week⁩ ago
  They decided to stop doing leap seconds.
  
  source
  - LastYearsIrritant@sopuli.xyz ⁨1⁩ ⁨week⁩ ago
    Until they decide to reverse it, or until they make a different change.
    
    Just use Epoch time for backend and calculations, and use local time for displaying to the user (or UTC for debugging systems that span time zones)
    
    source
- treadful@lemmy.zip ⁨1⁩ ⁨week⁩ ago
  Unix time is just a weird way of storing UTC time, since it’s just seconds relative to a UTC time.
  
  source