select to_char(systimestamp,'YYYY-MM-DD"T"HH24:MI:SS.FF2TZHTZM') from dual;
2018-02-07T11:43:37.47+0800
solved How to print system date in this format “2017-04-04T05:30:27.27-0700”
select to_char(systimestamp,'YYYY-MM-DD"T"HH24:MI:SS.FF2TZHTZM') from dual;
2018-02-07T11:43:37.47+0800
solved How to print system date in this format “2017-04-04T05:30:27.27-0700”