getdate SQL Convert to Long Format

,convert(varchar,getdate(),101) as [CONFIRMATION_DATE!1!REPORT_DATE]

The above displays as 8/26/2006, anyway you can convert that to a long format in the SP?

I.E. August 26, 2006

Thanks.

i think you are using c sharp code.
i dont know about c sharp. but in vb we do it like this

dim dt as string
dt = Format(Now, "MMMM DD,yyyy")

hope that it might help you.

|||Does thishttp://www.sql-server-helper.com/tips/date-formats.aspx help?|||

Why not simply using this:

select CONVERT(varchar,getdate())

For more information about converting DATETIME to various styles, please refer to the first table in this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

|||

thanks for the replies. The sql helper worked great.