I have a set of points (essentially tracks) with subsecond time precision, that would be useful to visualise/analyse. I have tried the "Convert Time Field" tool from string, float and double field types but the date/time field does not retain the sub second decimal. Also, the seconds value in the resulting date field is missing but replaced with the round millisecond value.
I have used String to Date with these formats:
yyyy-MM-dd HH:mm:ss.s ;
yyyyMMddHHmmss.s to one, two and three decimal places.
The results have been veried but most seem to lose the second values, either represent as
00 or the decimal value is represent in the seconds position.
There is not much on the forums or help pages or people having similar problems. Any ideas?
As a side note, the "Convert Time Field" tool does not like decimal seconds as base 10 values. The tool fails to convert any values above ##.6 of a second. So I have converted the decimal values to base 6. Therefore, 0.96 (base 10) converts to 0.58 (base6).