Home Forums SQL Server 2008 SQL Server Newbies Last 3 months data RE: Last 3 months data
rho_pooka
Ten Centuries
Points: 1385
More actions
January 22, 2014 at 6:35 pm
#1682635
Would something like this work? I wrote it in "notepad" so not sure if syntax is correct...
SELECT *
FROM Table
WHERE Time_Open <= GETDATE()
AND Time_Open >= DATE_SUB(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 3, 0)