RE: group by date question

2002-08-29 Thread Charles McElwee
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

Re: group by date question

2002-08-29 Thread S . Isaac Dealey
> 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? > datasou

group by date question

2002-08-29 Thread cc
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? SELECT logdate, DATEPA