Mixed-precision dataset

Some rows carry seconds, others milliseconds, others nanoseconds. A single numeric parse then places rows off by factors of 1000, scattering them across the wrong slots or epochs.

Class

Case to account for

Affects

1 conversion

Detection

Timestamp magnitudes cluster at 10-, 13-, or 16-digit lengths within one column.

Mitigation

Detect and normalize the unit per row before conversion; assert a plausible resulting year.

Affected conversions

Timestamp + zonehour-of-week slot

OPEN