Forum Discussion
QUESTION::PIPELINE::COPY DATA::MAPPING::DATETIMEOFFSET FORMAT
QUESTION: Does anyone know how to specify correctly the DateTimeOffset format of Copy data activity? ISSUE: The data source is on EST time and the Copy data activity should load the data into a...
A `datetime2` has no timezone information in it. Clients might _interpret_ it as being a local time in some timezone, but the Copy Data task will copy the value directy to a timetamp, which also has no timezone information.
Test by loading something like this:
select cast('2024-05-01 12:35' as datetime2(0)) dt
I suspect whatever tool you're using to examine the data is misleading you, or the view is doing something strange.
Are you saying that if my DATETIME2 column as date and time in EST, then it will be copied as such, with no changes, by Copy data?