Was wondering what would be the most efficient way to get data from today, does converting the date something like
WHERE CONVERT(CHAR(8),[DateTimeColumn],112) = CONVERT(CHAR(8),GETDATE(),112)
Not slow down the process as SQL essentially has to do a RBAR compare? Any thoughts or suggestions?
Please note that the column is datetime and it contains record insert date and time
