getting records from 'n' days ago against datetime field 1

[mbabcock]

I've got a table with a datetime field, and I want to create a Stored Proc that retrieves records 'n' days back using an input parameter. Kind of like this:

input parameter: @tiPastDays INT

declare @dPastDate
@dPastDate = CURRENT_DATE - @tiPastDays

select * from MyTable where tTheDateFieldToAnalyze >= @dPastDate

Mind you I'm dealing with dates only and don't care about the time portion.

tia!
--Michael

 

[SQLDenis]

one way

declare @tiPastDays int
select @tiPastDays =5

declare @dPastDate datetime
select @dPastDate = convert(varchar(10),dateadd(d, -@tiPastDays,getdate()),112)
--select @dPastDate

select * from MyTable where tTheDateFieldToAnalyze >= @dPastDate

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/