Hello team,

At the moment, date & time format for exported Dataverse tables on Azure Synapse Link have 3 different formats for the following columns

• SinkCreatedOn & SinkModifiedOn | M/d/yyyy H:mm:ss tt
• CreatedOn | yyyy-MM-dd'T'HH:mm:ss.sssssssXXX
• All other datetime columns | yyyy-MM-dd'T'HH:mm:ss'Z'

This would cause date & time management for them hard to manage. Therefore, I'm creating this Idea in order to request to make all 3 formats to be consistent. Thank you for your help.

Information gathered from: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/export-data-lake-faq#what-date-and-time-formats-can-be-expected-in-exported-dataverse-tables