Formatting JSON Dates

Question

Hi all,

I'm getting an OData dump from SAP by Design that is ingested into my companies ADLS gen2.

The dates however are coming over in the format like

/Date(1224043200000)/

Does anyone know how to convert this?

This particular date should read:

Thanks.

-prpatel

DataNath · Accepted Answer

I can get you close with something like this @prpatel - the core thing to note here is that SAP OData dates show as the number of milliseconds since Jan 1st, 1970:

In terms of getting the exact format, I don't think there are built in native functions but could probably hardcode this if needed.

binu_acs · Accepted Answer

@prpatel One way of doing this