.csv

Search services

Search tools and open pages quickly

Guida prodotto · 6 min di lettura

Date and time columns in CSV: ISO-8601, time zones, and locale traps

Prefer ISO-8601 in UTC for machine exchange; document locale-specific displays separately.

Pubblicato il 21 marzo 2025 · Table

Ambiguous dates like 01/02/2025 confuse US vs EU readers. Machine pipelines prefer 2025-01-02T15:30:00Z style timestamps with explicit offsets.

Policy

  • Store UTC in warehouses; convert to local only in presentation.
  • Never mix fractional seconds inconsistently across files.

← Tutti gli articoli

Usato da team leader

Loghi in scorrimento (ogni link apre il sito del brand): Google, Apple, Meta, GitHub, Stripe, Shopify, Databricks, Snowflake, Notion, Vercel, Intel, NVIDIA, Netflix, Spotify, Airbnb, Yale, Harvard University, Massachusetts Institute of Technology, Stanford University, University of California, Berkeley, Princeton University, California Institute of Technology, Columbia University, University of Chicago, Cornell University, Duke University, Carnegie Mellon University, Georgia Institute of Technology, Johns Hopkins University, Northwestern University, University of Toronto, McGill University, University of Oxford, University of Cambridge, Imperial College London, University College London, ETH Zurich, EPFL, Technical University of Munich, Sorbonne University, KU Leuven, National University of Singapore, Nanyang Technological University, Tsinghua University, Peking University, The University of Tokyo, KAIST, Seoul National University, University of Melbourne, Australian National University, University of Sydney, The University of Hong Kong.