Forum Discussion

Sandy's avatar
Sandy
New Contributor
4 years ago

DateTime Milliseconds issue with AZURE bulk load

Hi, When migrating data from DB2 to Azure using Azure bulk load snap, the milliseconds are not populating in Azure SQL tables ( data type used is datetime2(7) ). For milliseconds the data is coming...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

I cannot spot anything that might be the cause of the issue, except that the sample format you sent earlier is with 6 digits of milliseconds, and you need to send the value with 7 digits.

The expression can also be simplified by using

.toLocaleDateTimeString({"format":"yyyy-MM-dd HH:mm:ss.SSSSSSS"}) instead of manually combining the format where we can easily miscalculate indexes and send out a wrong date.

Regards,
Bojan