Formatting JSON Dates

[prpatel]

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 solution]

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 solution]

@prpatel One way of doing this

[prpatel]

@binu_acs & @DataNath,

Thank you both for your solutions.  Both seem to work.

As an FYI, this is considered to be an EPOC UNIX Date format.

Appreciate your insights on this.

-prpatel.