ORDS, SODA & JSON in the Database

Hi,

we are working in a systems integration, involving international connections. We define our services and the other team theirs.

We developed using the timestamp format already existing in ords, with a “T” before the time part and the Z or offset at the end.

We've found they are using a date format like this: Pattern (YYYY-MM-DD HH:MM:SS)

We asked them how can they know the time if they are not receiving the timezone, so they said we can convene to use UTC.

As I was sending local timestamp, now I'll have to convert to UTC. Well, it is a reasonable solution.

When I consume, I'm converting like this example:

SELECT TO_CHAR(CAST(SYSDATE AS TIMESTAMP) AT TIME ZONE 'UTC', 'YYYY-MM-DD HH24:MI:SS') AS utc_date
FROM DUAL;

Is there a better way to convert my dates?

What is in your opinion the standard way to treat this kind of problem?

Thanks