group by date question

I'm trying to group my query results by day. The field I'm grabbing from has a date/time stamp in it so what I'm getting are results grouped by time. I tried to fix this with this code which obviously doesn't work. How can I group this by date and ignore the time stamp? cfquery

Re: group by date question

I'm trying to group my query results by day. The field I'm grabbing from has a date/time stamp in it so what I'm getting are results grouped by time. I tried to fix this with this code which obviously doesn't work. How can I group this by date and ignore the time stamp? cfquery

RE: group by date question

by date question I'm trying to group my query results by day. The field I'm grabbing from has a date/time stamp in it so what I'm getting are results grouped by time. I tried to fix this with this code which obviously doesn't work. How can I group this by date and ignore the time stamp