Comparing dates

[3dColor]

<cfset today = CreateODBCDate(Now())>

<CFQUERY name="QofQtoday" dbtype="query">
   	SELECT 		*
   	FROM 		GetStats
	WHERE 		GetStats.timeStampStats = #today#
</CFQUERY>

My WHERE statement above is not working the way I would like. These two outputted dates {d '2006-01-13'} are not equal 2006-01-13 22:05:56.0. So my question is how do i reformat the date to so i can compare just the date and not the hours, minute, seconds?

I tried this but I get an conditional error.

DATE_FORMAT(GetStats.timeStampStats, %Y-%m-%d) = #today#

 

[guelphdad]

select foo, bar, qux
from yourtable
where date(yourdatetimecolumname) = current_date