| Subject | Grouping by Timestamp |
|---|---|
| Author | tickerboo2002 |
| Post date | 2004-04-29T14:22:57Z |
I have a table:
Call_ID integer
Call_Time timestamp
Call_Desc varchar(60)
and I need to plot a graph showing the volume of calls during the
dayin. I can imagine grouping by the timestamp by casting it to an
integer, but is there anyway I can group by 5,10,15,20,30,1hr intervals?
TIA
David
Call_ID integer
Call_Time timestamp
Call_Desc varchar(60)
and I need to plot a graph showing the volume of calls during the
dayin. I can imagine grouping by the timestamp by casting it to an
integer, but is there anyway I can group by 5,10,15,20,30,1hr intervals?
TIA
David