That does not give me the desired results: tsm: ULTSM> select date(pending_date) as "Date",count(*) from volumes where - cont> status='PENDING' group by pending_date
Date Unnamed[2] ---------- ----------- 2004-11-27 1 2004-11-27 1 2004-11-27 1 2004-11-27 1 2004-11-27 1 group by pending_date groups by the time stamp not the date stamp. I want a count of pending tapes by date not by second. >>> [EMAIL PROTECTED] 12/1/2004 10:02:40 AM >>> The group by statement is incorrect, use the following: group by pending_date the conversion to date format is already taken care of in the first part of the select statement. David E Ehresman wrote: > tsm: ULTSM> select date(pending_date) as "Date",count(*) from volumes > where - > cont> status='PENDING' group by "Date" > ANR2940E The reference 'Date' is an unknown SQL column name. > > | > > .........................................................V..... > e",count(*) from volumes where status='PENDING' group by > "Date" > > ANS8001I Return code 3. > > > >>>>[EMAIL PROTECTED] 11/30/2004 9:09:03 AM >>> > > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On > Behalf Of David E Ehresman > >>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? > > > Try > > select date(pending_date) as "Date",count(*) from volumes where > status='PENDING' group by "Date" > > -- > Mark Stapleton ([EMAIL PROTECTED]) > Berbee Information Networks > Office 262.521.5627