Re: SQL Select statement / Time & date question

From: Thomas Kellerer <spam_eater_at_gmx.net>
Date: Fri, 16 Jan 2004 15:54:31 +0100
Message-ID: <bu8tvf$en5kj$1@ID-13919.news.uni-berlin.de>

ext237 schrieb:

> Is there a way in SQL statement to count the number of records that updated
> per hour?
>
> For example, a table with these fields and records:
>
> trans_id trans_date
> --------- ------------
> 1 1/15/2004 12:18:33 PM
> 2 1/15/2004 2:07:01 PM
> 3 1/15/2004 2:10:12 PM
>
> I need my report to say:
>
> hour num_of_trans
> ---- --------------
> 12 PM 1
> 2 PM 2
>
> Any hints?
>

select to_char(trans_date, 'HH24'), count(*) from table
group by to_char(trans_date, 'HH24') Received on Fri Jan 16 2004 - 08:54:31 CST