By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| TO_TIMESTAMP('3005231429','DDMMYYHH24MI') |
|---|
| 30-MAY-23 14.29.00.000000000 |
| TO_CHAR(TO_TIMESTAMP('3005231429','DDMMYYHH24MI'),'DD/MM/YYYYHH24:MI') |
|---|
| 30/05/2023 14:29 |