Why Is the Offset Removed from the DateTimeOffset Fields in the Destination?

Question

Why is the time zone offset removed from my SQL Server DateTimeOffset fields when I sync them to the destination?

Environment

Connector: SQL Server

Answer

Fivetran converts SQL Server DateTimeOffset values to UTC before storing them in the destination. During this process, we remove the original time zone offset and store the values with a +00:00 offset. For example:

• Original value: 2022-12-03 08:33:37.000 -10:00
• Synced value: 2022-12-03 18:33:37.000 +00:00

For more information, see SQL Server type transformation and mapping.