Hi,

try this

Declare @RESULT datetime

set @RESULT = getdate()

--

select (cast(day(@RESULT) as varchar)+

(case when (right(day(@RESULT),1) >= 4)

or(right(day(@RESULT),1)= 0)

or((left(day(@RESULT),1) = 1)and len(day(@RESULT))= 2) then 'th'

when right(day(@RESULT),1) = 1 then 'st'

when right(day(@RESULT),1) = 2 then 'nd'

when right(day(@RESULT),1) = 3 then 'rd'

end)+

space(1)+

datename(mm,@RESULT)+

space(1)+

cast(year(@RESULT) as varchar))