JSON Date Format

[Former Member]

Hi,

We have a Gateway service with some date fields (ABAP datatype DATS converted to Edm.DateTime or Edm.DateTimeOffset).

When service is called with output format JSON, date values are represented in MicrosoftDateFormat format (e.g. "/Date(1448841600000)/").

In contrary, when output format is XML, dates are in ISO-8601 format: YYYY-MM-DDThh:mm:ssTZD (e.g. 1997-07-16T19:20:30+01:00).

Is there any way to change the JSON date format, either in field level or system level?

[Former Member]

Hi Shai,

Unfortunately those are the standard ones for XML(ISO-8601) and JSON (Epoch) respectively.

If you want to change the output at system level for JSON, use an EDM.String to represent the formated datetime you want. For UI which will use the Epoch datetime, there are several libraries that convert Epoch to human readable time. Our UI devs prefer the latter but it depends on your requirement.

Regards,

Francis

[Former Member]

For the matter of fact, we don't have a real problem with Epoch format. The main issue is with MicrosoftDateFormat format (the hybrid "/Date(Epoch)/").

It will require our service consumers to develop a special (very simple) parser