Invalid time because of daylight saving time not converted properly
Opened this issue · 0 comments
amuneric commented
This time stamp
14MAR2010:02:00:00.000000
converted with this
conversion:enhance [
ov:csvCol 3;
ov:csvHeader "datetime";
conversion:equivalent_property bpr:datetime;
conversion:pattern "ddMMMyyyy:HH:mm:ss.ssssss";
conversion:comment "";
conversion:range xsd:dateTime;
];
converts as an untyped literal.
While this is a timestamp that shouldn't exist due to the jump to daylight savings, it seems reasonable to me that this get jumped (treat it as 14MAR2010:03:00:00.000000) and then typed.
5 million datetimes in my database, 101 datetimes untyped, 1/2 day scratching my head.