Hi All,

Thank you for your valuble reply .. finally am able to over come my prob .. here is the query

Declare @date Datetime='2013-06-16 00:00:00.000'

select REPLACE(Convert(Varchar(25),CASE WHEN MONTH(@date)=1 THEN 12

WHEN (LEN(MONTH(@date))=2 AND MONTH(@date)<>10) THEN MONTH(@date)-1

ELSE

'-' + CONVERT(VARCHAR(5),MONTH(@date)-1 ) END),'-','0')

Regards,

Ravi@sql