Azure / Azure/Azure-DataFactory
Mapping Dataflow - incorrect conversion when using toTimestamp for certain values
Open
- 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
Assessment
This issue has not been assessed yet.