how to convert below query from Oracle PL/SQL to MS SQL Server
to_date(to_char(cm_firstfinishdate,'MON YY'),'MON YY')
here cm_firstfinishdate = 2013-08-27 of datatype date
for.. to_char(cm_firstfinishdate,'MON YY')
I have done UPPER(RIGHT(CONVERT(VARCHAR(10), cm_firstfinishdate, 6),6))
which works fine,
how to convert the same to to_date
please assist me