i am working with ODATA API and the date field i am getting is in JSON date format eg: /Date(1562918858000)/

kishan ranka 6 Reputation points
2021-06-30T08:07:47.347+00:00

i need to convert that date /Date(1562918858000)/ in normal date format

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,723 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 30,426 Reputation points Microsoft Employee
    2021-07-01T06:20:27.217+00:00

    Hi @kishan ranka ,

    Welcome to Microsoft Q&A Platform. Thank you for posting your query.

    • To format Dates in Azure data factory, Pipeline expressions you can use: formatDateTime() function.
    • To format Dates in Azure data factory, Data flow expressions you can use: toDate() fucntion.

    Between, in your case "1562918858000" is not giving any sense of date format. Could you please help me to interpret date format in that?

    Hope this helps. Thank you.

    -------------------------------------------

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a email-notifications