• DECLARE @Expiry_Date DATETIME = '2012-12-25 00:00:01.003'

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

    Gives me an output of

    (Expires December 25, 2012)