By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select to_char(
to_timestamp_tz(
'2021-09-07T18:24:25.075+02:00',
'yyyy-mm-dd"T"hh24:mi:ss.ffTZH:TZM'
),
'dd.mm.yyyy hh24.mi.ss'
) AS timestamp
from dual
| TIMESTAMP |
|---|
| 07.09.2021 18.24.25 |