Code:SQL> select to_char(to_date(substr('&datum',3),'YY-MM'),'YYYYMM') datum from dual; Enter value for datum: 2102-11 old 1: select to_char(to_date(substr('&datum',3),'YY-MM'),'YYYYMM') datum from dual new 1: select to_char(to_date(substr('2102-11',3),'YY-MM'),'YYYYMM') datum from dual DATUM ------ 200211 SQL>




Reply With Quote