RE: sql query

From: Guidry, Chris <chris.guidry_at_atcoelectric.com>
Date: Mon, 07 May 2001 11:58:56 -0700
Message-ID: <F001.002FB3A3.20010507120233@fatcity.com>

Hello,

SELECT COUNT(*), TO_CHAR(<date column>, 'DD-MON-YYY:HH24') FROM <your table>
GROUP BY TO_CHAR(<date column>, 'DD-MON-YYY:HH24');

HTH

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: chris.guidry_at_atcoelectric.com



> -----Original Message-----

> From: Ravindra Basavaraja [SMTP:ravindra_at_sentica.com]

> Sent: Monday, May 07, 2001 01:41 PM

> To:   Multiple recipients of list ORACLE-L

> Subject:      sql query

> 

> I want to get count of records that are generated every hour.(group by

> hour).

> Since the date field will have timestamp varying every second how do I

> group

> a set of records for every hour.

> 

> Like

> 

> count(*)      Time(in hour)

> -------       -------------

> 10            00-01

> 20            01-02

> 30            02-03 like wise for every hour.

> 

> Can i do this by using the GROUP BY clause.If so pls help me.

> 

> Thanks

> Ravindra

> 

> -- 

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> -- 

> Author: Ravindra Basavaraja

>   INET: ravindra_at_sentica.com

> 

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> the message BODY, include a line containing: UNSUB ORACLE-L

> (or the name of mailing list you want to be removed from).  You may

> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: chris.guidry_at_atcoelectric.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon May 07 2001 - 13:58:56 CDT