Date conversion

Hello All,

I need help in converting a date. What i'm looking for is date in format of mm/yyyy.

Thanks in advance.

select substring(convert(varchar(12),getdate(),103),4,7)



------------
mehool at 3/19/01 9:53:31 AM


Hello All,

I need help in converting a date. What i'm looking for is date in format of mm/yyyy.

Thanks in advance.