Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT TO_CHAR(
         TO_DATE(
           '2019-01-21T19:02:25Z',
            'yyyy-mm-dd"T"hh24:mi:ss"Z"'
         ),
         'dd/mm/yyyy hh24:mi:ss'
       )
FROM   DUAL;


TO_CHAR(TO_DATE('2019-01-21T19:02:25Z','YYYY-MM-DD"T"HH24:MI:SS"Z"'),'DD/MM/YYYYHH24:MI:SS')


21/01/2019 19:02:25


SELECT TO_CHAR(
         TO_TIMESTAMP_TZ(
           '2019-01-21T19:02:25Z',
            'yyyy-mm-dd"T"hh24:mi:ssTZHTZM'
         ),
         'dd/mm/yyyy hh24:mi:ss'
       )
FROM   DUAL;


TO_CHAR(TO_TIMESTAMP_TZ('2019-01-21T19:02:25Z','YYYY-MM-DD"T"HH24:MI:SSTZHTZM'),'DD/MM/YYYYHH24:MI:SS')


21/01/2019 19:02:25


SELECT TO_CHAR(
         TO_TIMESTAMP_TZ(
           '2019-01-21T19:02:25Z',
            'yyyy-mm-dd"T"hh24:mi:ssTZR'
         ),
         'dd/mm/yyyy hh24:mi:ss'
       )
FROM   DUAL;


TO_CHAR(TO_TIMESTAMP_TZ('2019-01-21T19:02:25Z','YYYY-MM-DD"T"HH24:MI:SSTZR'),'DD/MM/YYYYHH24:MI:SS')


21/01/2019 19:02:25