Re: Count on a date column

From: Nigel Rivett (sqlnr_at_hotmail.com)
Date: 05/19/04

  • Next message: Raul Villaronga: "Returning TEXT data in a Stored Procedure" 
    Date: Wed, 19 May 2004 05:49:01 -0700

    select count(*)
    from tbl
    where convert(varchar(8),dte,112) = '20040515'

    select count(*)
    from tbl
    where dte >= '20040515' and dte < '20040515'

    select dte = convert(varchar(8),dte,112), num = count(*)
    from tbl
    group by convert(varchar(8),dte,112)
    order by convert(varchar(8),dte,112)

    one of those should help.

    Nigel Rivett
    www.nigelrivett.net

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!

  • Next message: Raul Villaronga: "Returning TEXT data in a Stored Procedure"