DROP FUNCTION dbo.udf_FullDatetoString
GO

CREATE FUNCTION dbo.udf_FullDatetoString (@Date DATETIME)
RETURNS VARCHAR(30)
AS

/*****************************************************
Purpose.  Converts standard datetime value
         to a formatted date string
        
         e.g.  2012-06-22 13:54:39.993 becomes 'Friday, 22nd Jun 2012'

         Ideal for reports
        
Author:      Unknown
History:  22 Jun 2012 - Initial Release
******************************************************/

BEGIN

-- not a pretty command, but it doesn't really fit well to a page.
RETURN
    DATENAME(dw,GETDATE()) +', '
   + STUFF(CONVERT(CHAR(11),GETDATE(),106),3,0, SUBSTRING(
   'stndrdthththththththththththththththththstndrdthththththththst '
    ,(DATEPART(DAY,GETDATE())*2)-1,2))
                                                                  
END

-- select dbo.udf_FullDatetoString (GETDATE())