question

kishanranka-5761 avatar image
0 Votes"
kishanranka-5761 asked ShaikMaheer-MSFT commented

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

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

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @kishanranka-5761 ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @kishanranka-5761 ,

Following up to see if the above suggestion was helpful. If yes, Please Accept Answer. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @kishanranka-5761 ,

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 


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.