Hello,
I want to ask if anyone has a solution to how to allow a date field datatype to export to Azure Storage Explorer through an Azure Data Factory process with the same date data type as from Azure SQL Database table ((note: the data type for date field in the SQL table is datetime2(0)). In the SQL database table, the date does not include the milliseconds but in the Azure Storage Explorer .txt file it has the milliseconds.
Example of how the date appears in the SQL table
NameDateSue2023-01-31 00:00:00Bob2023-02-28 00:00:00An example of how the data appears in Azure Storage Explorer (as a .txt file) once table above ran through the azure data factory process
Name|Date
"Sue"|2023-01-31 00:00:00.0000000
"Bob"|2023-02-28 00:00:00.0000000