How to remove time from date parameter

[titans4771]

I have the below parameter being passed in:

Declare @rundate datetime
Set @rundate = dateadd(dd,-3,getdate())
select @rundate

It currently returns:
2009-09-11 11:07:30.487


How can I get it to return:

2009-09-11 00:00:00.000

 

[gmmastros]

Select DateAdd(Day, DateDiff(Day, 0, @rundate), 0)

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[titans4771]

Thanks!

 

[markros]

See also

The ultimate guide to the datetime datatypes