By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;
| BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
|---|---|---|---|
| Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 |
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | 0 |
create table demots ( ts TIMESTAMP(6) );
insert into demots(ts) values ( TO_TIMESTAMP('21.04.2022 14:25:00', 'DD.MM.YYYY HH24:MI:SS') );
1 rows affected
SELECT TO_CHAR(ts, 'YYYY-MM-DD HH24:MI:SS') tsx FROM demots;
| TSX |
|---|
| 2022-04-21 14:25:00 |