Date format in rest API response

[oceansmoving]

API: Aggregated table

Table: Incident_SLA

When I return 'inc_opened_a', is it possible to format the date differently in the query?

Current format: yyyy-mm-dd hh:mm:ss

Preferred format: yy-mm-dd

Reason is, that I would like to aggregate and response based on date, and not date + time

[Daniel Gurney1]

It would be great, and preferable, if ServiceNow would return dates in RFC-3339 format in UTC time zone, so that the calling application does not need to know the ServiceNow time zone.

Ex:

what is is now:

  sys_created_on:  "2019-10-28 07:03:05"

should be:

  sys_created_on:  "2019-10-28T03:03:05Z"