this post was submitted on 16 Oct 2024
176 points (90.7% liked)

Technology

58719 readers
4914 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots


founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 3 points 19 hours ago (1 children)

Unrelated to the topic, but I deal with a database storing timestamps.

In local time.

For systems all around the world.

You'll see current entries timestamped 12:28 from eastern Europe followed by ones 6:28 from America and then another 11:28 from central Europe.

Without offset.

[–] [email protected] 4 points 10 hours ago

Ew. Just store UTC timestamps and do optional translation on the client using whatever the client sets up for their timezone. It's not hard...