From: NeilC <neil-olos@NOSPAMbt.com>
Subject: SQL help needed
Date: 2000/04/25
Message-ID: <39059EB8.7301820A@NOSPAMbt.com>#1/1
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: postmaster@axion.bt.co.uk
X-Trace: pheidippides.axion.bt.co.uk 956669734 18556 147.147.57.116 (25 Apr 2000 13:35:34 GMT)
Organization: UK
Mime-Version: 1.0
NNTP-Posting-Date: 25 Apr 2000 13:35:34 GMT
Newsgroups: comp.databases.oracle.server


Hi

I have a column of type date in a table, and I want to be able to
produce a report showing the number of records for each hour - any body
able to help ?

output would look something like

01:00	10
02:00	6
03:00	5
.
.
.
23:00	132
00:00	99

Many thanks in advance

Neil