I am using ADF pipeline copyData to extract from MS SQL Server to a CSV. Several columns in this table are defined as data type Time. Looking in the database, a time of for example, 14:31:59 appears in the CSV as 0:14:31:59.0000000
Notice the leading 0:
I believe that this is an error. Noticed because I cannot import into the data warehouse. There is no custom treatment of the data, no mapping, just a simple copy.
Is there a fix? Is there an obvious way to deal with this (other than chop off the leading 0: -- which will break if it is fixed)?







