you dont want day then you have to modify your nls_date_format parameter or change back to char again
select to_char(to_date(a, 'RRMM'), 'MON-RR') from x
|
Results 1 to 5 of 5
Thread: Varchar2(4) - DateThreaded View
|
Click Here to Expand Forum to Full Width |