Can this query be improved so I don't have to check the day, month, and year? I just want updt equal to the current date, regardless of the time.
I tried WHERE updt=getdate() but I don't get the correct result. Thanks.
where day(updt) = day(getdate())
and month(updt) = month(getdate())
and year(updt) = year(getdate())