I often import data from .csv files which contain time values stored in 24 hour format, e.g. 08:05:23. Using Table To Table, these fields usually import as Text type fields, no problem.
However I've just noticed - if it can, ArcGIS Pro will actually convert these fields to Date type fields, and convert the time to a date. For example, 08:05:23 becomes 08/05/2023, which clearly isn't correct.
It seems that this process is only prevented if at least one time value in the field cannot be interpreted as a date, e.g. 08:45:23 will prevent the conversion because there is no month '45'.
Does anyone know a way to prevent this? I would have thought text with format ##:##:## is better interpreted as a time value rather than a date value.
Thanks, Tim