Thanks, this and the from ISC Edwin Cruz helped, it what I was wanting.
Payne
Sameer wrote:
Payne wrote:
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
select count(*), DATE_FORMAT(some_date, '%Y-%m-%d') from some_table
group by DATE_FORMAT(some_date, '%Y-%m-%d');
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]