Home Forums SQL Server 2005 Development sp_send_dbmail - date compare in query-variable RE: sp_send_dbmail - date compare in query-variable

  • September 23, 2013 at 5:02 am

    #1652290

    SELECT DATEADD(HH,14,CAST(DATEADD(DD,-1,CAST(GETDATE() AS DATE)) AS DATETIME)) AS "Yesterday'sDate@2O'Clock"