By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
alter session set nls_date_format = 'SYYYY-MM-DD HH24:MI:SS';
select to_date('210408092508', 'yy/mm/dd HH24:MI:SS') from dual;
| TO_DATE('210408092508','YY/MM/DDHH24:MI:SS') |
|---|
| 2021-04-08 09:25:08 |
select to_date('210408091706', 'yy/mm/dd HH24:MI:SS') from dual;
| TO_DATE('210408091706','YY/MM/DDHH24:MI:SS') |
|---|
| 2104-08-09 17:06:00 |
select to_date('210408092508', 'FXyy/mm/dd HH24:MI:SS') from dual;
ORA-01861: literal does not match format string
select to_date('210408091706', 'FXyy/mm/dd HH24:MI:SS') from dual;
ORA-01861: literal does not match format string
select to_date('210408092508', 'YYMMDDHH24MISS') from dual;
| TO_DATE('210408092508','YYMMDDHH24MISS') |
|---|
| 2021-04-08 09:25:08 |
select to_date('210408091706', 'YYMMDDHH24MISS') from dual;
| TO_DATE('210408091706','YYMMDDHH24MISS') |
|---|
| 2021-04-08 09:17:06 |
select to_date('210408092508', 'RRMMDDHH24MISS') from dual;
| TO_DATE('210408092508','RRMMDDHH24MISS') |
|---|
| 2021-04-08 09:25:08 |
select to_date('210408091706', 'RRMMDDHH24MISS') from dual;
| TO_DATE('210408091706','RRMMDDHH24MISS') |
|---|
| 2021-04-08 09:17:06 |