From: Mogens Melander
Date: April 29 2007 7:00am
Subject: Re: how to query this sql?
List-Archive: http://lists.mysql.com/mysql/206427
Message-Id: <1169.90.184.17.152.1177830004.squirrel@mail.fumlersoft.dk>
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit


On Sun, April 29, 2007 05:28, Jeff Pang wrote:
> Hello list,
>
> I want to get the counter for db-items by each day,so I wrote this sql:
>
>  select count(*) as dd from items group by updatetime;
>
> But sorry "updatetime" is "datetime" type,not "date" type.Then I can't get
> the correct result.
>
> How can I do this?Thanks.
>

That would be

select date(updatetime) ut, count(*) dd
from items group by ut;

-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224



-- 
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.