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

[BJ Swope]

select count(*), substring(timeofclick,1,7) from MTracking where
mallarea=1001 group by 2;



On 5/3/06, Randy Paries <[EMAIL PROTECTED]> wrote:

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]