Earlier today, I saw on Lemmy that comments made within the last hour since DST were now in the negatives since time had rolled back. If a database uses time like this for search operations, would that interfere with them? Could it corrupt the database?

  • LastYearsIrritant@sopuli.xyz
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 days 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)