Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> group by hour?

group by hour?

From: <edwards_at_garland.dnr.state.sc.us>
Date: 1997/04/08
Message-ID: <334A8EB0.2781@garland.dnr.state.sc.us>#1/1 







is it possible to group  by the hour or day of a date?


	select avg(temperature),date from weather
		group by date%DAY





Does anyone know how to do this?
Received on Tue Apr 08 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US