let sysdate='19-SEP-2009' select round(sysdate,'YEAR'),round(sysdate,'MONTH') from dual would results in?
09,SEP
1/1/2010,1/10/2009
1/1/2009,1/1/2009
2009,SEPTEMBER