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, Ong
[Non-text portions of this message have been removed]

