help me in sql query

Question

please help me change below query for last 30 days. Below query gives me output for last 6 month.

DECLARE @StartDate DATETIME, @EndDate DATETIME

SET @StartDate = dateadd(mm, -6, getdate())

SET @StartDate = dateadd(dd, datepart(dd, getdate())*-1, @StartDate)

SET @EndDate = dateadd(mm, 6, @StartDate)

SELECT  TOP 10000 CONVERT(DateTime,

LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),

101) AS SummaryMonth,

Nodes.Caption AS NodeName,

Nodes.IP_Address AS IP_Address,

AVG(DailyNodeAvailability.Availability) AS AVERAGE_of_Availability

FROM

Nodes INNER JOIN DailyNodeAvailability ON (Nodes.NodeID = DailyNodeAvailability.NodeID)

WHERE

( DateTime BETWEEN @startDate AND @EndDate )

AND (Nodes.unmanaged=0)

AND (Nodes.firewall=0)

AND CONVERT(varchar, DateTime,108) NOT BETWEEN '01:00:00' AND '03:00:00'

GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),

Nodes.Caption, Nodes.IP_Address

ORDER BY SummaryMonth ASC

njoylif · Accepted Answer

Interesting way to do it....try this:

DECLARE @StartDate DATETIME, @EndDate DATETIME

SET @StartDate = dateadd(day, -30, getdate())

SET @StartDate = dateadd(dd, datepart(dd, getdate())*-1, @StartDate)

SET @EndDate = dateadd(day, 30, @StartDate)