this post was submitted on 23 Feb 2025
491 points (79.7% liked)

Technology

63186 readers
4972 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 other!
  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
  10. Accounts 7 days and younger will have their posts automatically removed.

Approved Bots


founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] nickwitha_k@lemmy.sdf.org 1 points 4 hours ago

"make all the dates in this CSV iso-8601"

This is a use of AI/LLM processing that I could agree with, if it could be trusted. Since it cannot, better to open in vim and regex replace, or process with Python.

That said, I'd rather store as epoch and display as ISO-8601 as the arithmetic is much less prone to error in epoch than any other format.