Hello,
Our database stores column as date but we need to convert it to specific timestamp format, for example: "01/31/1970T12:04:12.000GMT+00:00".
It is now done as:
select
to_char( cast(sysdate as timestamp(3) with local time zone)
, 'MM/DD/YYYY"T"HH24:MI:SS.FF"GMT+00:00"' )
from dual;
As you can see it has
- hardcoded time zone part
- looks a bit ugly
The requirement is that it must contain timezone expressed as "GMT<+/-><hours:minutes>" and "T" letter between <date> and <time> part of a datetime (BTW: is this some generic format for timestamps?). Can the format above be obtained in better way? The less hardcoding the better...
Thank you