to_char function, I want to extract emp joining date as mm/dd/yy format using to_char Options

[thiyagusham]

my table having doj 30-jan-2003


SQL> select to_char(date_of_joining,'yyyy') from t1;
select to_char(date_of_joining,'yyyy') from t1
*

ERROR at line 1:
ORA-01722: invalid number

[Munchun Singh]

Hi,

First date_of_joining convert to TO_Date then use TO_CHAR

SELECT TO_CHAR(TO_DATE(DATE_OF_JOINING),'YYYY') FROM T1;



--
Neeraj Kumar Singh