• AggressivelyPassive@feddit.de
    link
    fedilink
    arrow-up
    3
    ·
    7 months ago

    Epochs aren’t that simple either.

    First of all, local time can be relevant, so you have to store timezone information somewhere anyway.

    Epochs are also somewhat iffy in regards to leap years or seconds.

    And finally: write me an SQL to retrieve all entries submitted in 2022 using just epochs.

    Timezones are annoying as fuck, don’t get me wrong, but simply ignoring them isn’t a solution either.

    • AeroLemming@lemm.ee
      link
      fedilink
      English
      arrow-up
      1
      ·
      7 months ago

      I don’t really remember SQL, does it prevent you from using a range of values? I can understand why leap seconds would be an issue.