With CONVERT function (in SQL). Read more about this
function and you will find the solution.
--- soonhuat ong <[EMAIL PROTECTED]> wrote:
> 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]
>
>
