dateTime

This data type represents a point in time (date and time).

The display depends on the selected format and the protocol.

Settings
MIME Format and Protocol Result

You have set UrlEncoded and no protocol.

The date and time are converted into the format yyyy-MM-ddTHH:mm:ss.fff.

UrlEncoded and one of the following protocols:

  • ODATA V2

  • ODATA V3

  • ODATA V4

The date and time are converted into the format datetime'yyyy-MM-ddTHH:mm:ss.fff'.

You have set JSON as MIME format and no protocol.

The date and time are converted into the format yyyy-MM-ddTHH:mm:ss.fff‘.

You have set JSON and the ODATA V2 protocol.

The date and time are converted into the format /Date(ticks)/. The ticks represent the milliseconds that have passed since January 1, 1070.

You have set JSON and the ODATA V3 or ODATA V4 protocol.

The date and time are converted into the format datetime' yyyy-MM-ddTHH:mm:ss.fff'.

You have set XML and no protocol.

The date and time are converted into the format yyyy-MM-ddTHH:mm:ss.fff.

You have set XML and one of the following protocols:
  • ODATA V2

  • ODATA V3

  • ODATA V4

  • SOAP

The date and time are converted into the format yyyy-MM-ddTHH:mm:ss.fffffff.

You have set XML and the ODATA V4 protocol.

The date is converted into the format yyyy-MM-dd.