Interactive publication
Back to the catalogueData qualityCase 03 of 05
Naive datetime with no zone
A stored '2026-03-08 02:30' with no offset and no accompanying zone cannot be resolved to a slot — and, unluckily, that particular value does not even exist in US Eastern. Zone-less local timestamps are the most common warehouse hazard.
Class
Case to account for
Affects
1 conversion
01
Detection
Timestamp string carries no offset and no zone column travels with it.
02
Mitigation
01
Require an accompanying IANA zone; reject naive timestamps rather than assuming UTC.
03
Affected conversions
Timestamp + zonehour-of-week slot
OPEN