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

Hi @Sandy,

Can you send one sample date that goes into Azure?

Thank you

  • Sandy's avatar
    Sandy
    New Contributor
    4 years ago

    Hi

    Here is the sample date which goes from DB2 to Azure SQL.
    ‘2022-11-16 03:27:20.038261’.

    I am using this to extract the timestamp

    ($LAST_UPDT_TIMESTAMP != null) ? ( $LAST_UPDT_TIMESTAMP .toString().substr(0,10) +" "+ $LAST_UPDT_TIMESTAMP .toString().substr(11,8) + “.” + $LAST_UPDT_TIMESTAMP .toString().substr(14,7) ) : null

    Thank you.