Azure / Azure/Azure-DataFactory

Mapping Dataflow - incorrect conversion when using toTimestamp for certain values

Open
#360 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
PowerShell
Stars
529
Forks
623
PR merge metrics
No merged PRs in 30d

Description

I am using a toTimestamp function to convert a string to timestamp.
But certain values convert to incorrect date:

`toTimestamp("0001-01-01T05:51:00Z","yyyy-MM-dd'T'HH:mm:ss'Z'") -> 0000-12-30 05:51:00.000`

When I store these values in the delta table and query back using SQL pool I get value out of date range error:

**Error handling external file: 'Value is out of DATETIME range...**

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.