Delphi + MsSQL - DateFormat

Hi all,

Currently i wrote a StoreProc to get today date.
Anyway, I want the date to have the following format:

'22nd day of May 2008' How can i do it ??

I use DatePart function, but it will only return me the integer value
How can i get something like 'May', or 22nd ??

I know this can be done using Delphi FormatDateTime but i need it in my StoreProc Anyone

Thanks in Advance,

Regards,




[Non-text portions of this message have been removed]