c# - Comparing current date in stored procedure -

I am trying to check a stored function in the table on a date if it is equivalent to today's date.

  code DECLARE @ p0 datetime set @ p0 = GETDATE () * select * from testtable where dateCol = @ p0   
 it just does not work How do I do this blank lines? Thank you   
 
 
 If dateCol is only a date, no DATETIME, you can use:  < Pre>  SELECT * to table WHERE dateCol = CAST (GETDATE () AS DATE)