Hi,

I having a problem doing a simple count with the way date is format 2005-12-11 21:49:36, what I am wanting to do is a simple count where it only returns just the date. What do i need to do to get it where is (2005-12-11) and for that matter switch the date to us format. Here the sql statement I am doing now.

select count(*), date from my_db group by date;

Thanks, for any help you can give me.

Payne




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

Reply via email to