I noticed this happening in a Oracle ORDS REST GET data service I have created from the Apex designer. It was returning a date that had 01-APR-2020 in it in the database column (no time element) as 31st March 2020 23:00
I just recreated a simple test case, I created a GET service with a simple query thus:
select to_date('01-APR-2020', 'DD-MON-YYYY') april_1st from dual
The type is "Collection Query"
I execute this GET service from Postman and I see this json coming back
"items": [
{
"april_1st": "2020-03-31T23:00:00Z"
}
I guess it's something to do with time zone. I have read around but not found the issue/solution.
Can anyone help shed any light on this for me please?