Help with this query. How to do a group by on a datetime just the month/day/year

[Randy Paries]

Hello,

Not sure if i can do this.

I have a table with a datetime column

I would like to do group by a day of the month.

if i do something like

select count(*) from MTracking where mallarea=1001 group by timeofclick

every one is listed because time.

So is this possible?

Thanks
Randy

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]