on 12/15/05 4:51 PM, Payne at [EMAIL PROTECTED] 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;
select count(*), DATE_FORMAT(date, '%c/%d/%Y') from my_db group by date; -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]