Joni,

Try something like : where days(current_timestamp)-days(pending_date) =1
This should work !
Cheers.  


Arnaud 

************************************************************************
******
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
************************************************************************
******

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Tuesday, 05 July, 2005 17:10
To: ADSM-L AT VM.MARIST DOT EDU
Subject: incompatible operator

Hello Everyone!

I think I had this issue before, but I can't seem to find the solution
to it.  Any suggestions as to why this will not work?  I am trying to
get that listing pinpointed to reporting each tape on the first day that
it becomes "pending" and it just doesn't see to like my syntax.  Thanks!

ANR2916E The SQL data types DATE and TIMESTAMP are incompatible for
operator '<'.

                                        |
         ...............................V...............................
         ENDING' and date(pending_date) < (current_timestamp - 1 day) an

select volume_name,date(pending_date) from volumes where
stgpool_name='TAPE_NDMP_OFFSITE' and devclass_name='NASDEV' and
status='PENDING' and date(pending_date) < (current_timestamp - 1 day)
and volume_name like 'N%' order by volume_name
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************