Home Forums SQL Server 2008 SQL Server 2008 - General Date format RE: Date format

  • December 19, 2012 at 2:06 am

    #1569932

    SELECT '(Expires '+RTRIM(DATENAME(MM, GETDATE()) +','+ RIGHT(CONVERT(VARCHAR(12), GETDATE() ,107),9))+ ')'

    Gives

    (Expires December, 19, 2012)