That groups things by a time stamp which results in a count of one for
each time stamp.  I'm trying to get a count by date, not by
minute/second.

David

>>> jchoate AT SOURCE1INC DOT COM 11/30/2004 8:16:10 AM >>>
Try this.

select date(pending_date), count(*) from volumes where -
status='PENDING' -
 group by pending_date


________________________________

From: ADSM: Dist Stor Manager on behalf of David E Ehresman
Sent: Tue 11/30/2004 6:10 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SQL Help



I'm trying to get a count of tapes pending by date.  I'm using:
        select date(pending_date),count(*) from volumes where
status='PENDING' -
   group by date(pending_date)
but I get the error message:
   ANR2904E Unexpected SQL key word token - 'DATE'.
pointing to the date in the group by clause.

Anyone know how to get a pending count by date?

David