Sorry, I fogot to mention that I would like the input to only show the time
port such as:

8:15:00

Lee

>
>
> Hello all,
>
> I need to be able to graph out time values in a cross tab
> type of format in a report. The values are in a timestamp
> field with the time portion in 15 minute increments.
>
> Ex.
> 1/2/2005 08:00:00
> 1/2/2005 08:15:00
> 1/2/2005 08:15:00
> 1/2/2005 08:30:00
> 1/2/2005 08:45:00
> 1/2/2005 08:45:00
>
> I need to pull the records out Grouped on the minute portion
> for a particular date so that the actual output would be:
>
> Date COUNT
> -----------------------------
> 1/2/2005 08:00:00 1
> 1/2/2005 08:15:00 2
> 1/2/2005 08:30:00 1
> 1/2/2005 08:45:00 2
>
> Can somone offer assistance, possible an example?
>
> Thank you,
> ---
> Lee
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources
> item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>