Interactive publication
Back to the catalogueData qualityCase 02 of 05
Local timestamps read as UTC (or vice versa)
A column stored in local time is read as UTC, or a UTC column is read as local. Every event shifts by the offset, biasing every slot systematically — the diurnal curve peaks at the wrong hour.
Class
Case to account for
Affects
1 conversion
01
Detection
The aggregate diurnal shape is shifted by a constant offset from the expected shape.
02
Mitigation
01
Pin each timestamp column's zone in the schema; validate the diurnal shape after ingest.
03
Affected conversions
Timestamp + zonehour-of-week slot
OPEN