产品指南 · 6 分钟阅读
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.
发布于 2025年3月21日 · 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.