By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (column_name TIMESTAMP WITH TIME ZONE);
INSERT INTO table_name (column_name)
SELECT TO_TIMESTAMP_TZ('30/03/2022 Europe/Paris', 'DD/MM/YYYY TZR') FROM DUAL UNION ALL
SELECT TIMESTAMP '2022-03-30 00:00:00 Europe/Paris' FROM DUAL UNION ALL
SELECT FROM_TZ(TO_TIMESTAMP('30/03/2022', 'DD/MM/YYYY'), 'Europe/Paris') FROM DUAL;
3 rows affected
ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF TZR';
SELECT * FROM table_name;
| COLUMN_NAME |
|---|
| 2022-03-30 00:00:00.000000 EUROPE/PARIS |
| 2022-03-30 00:00:00.000000 EUROPE/PARIS |
| 2022-03-30 00:00:00.000000 EUROPE/PARIS |