This will also work,

date(pending_date) < date(current_timestamp - 1 day)

Computer says 'No'..


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Tuesday, July 05, 2005 4:10 PM
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
********************************



___________________________ Disclaimer Notice __________________________
This message and any attachments are confidential and should only be read by 
those to whom they are addressed. If you are not the intended recipient, please 
contact us, delete the message from your computer and destroy any copies. Any 
distribution or copying without our prior permission is prohibited.

Internet communications are not always secure and therefore Powergen Retail 
Limited does not accept legal responsibility for this message. The recipient is 
responsible for verifying its authenticity before acting on the contents. Any 
views or opinions presented are solely those of the author and do not 
necessarily represent those of Powergen Retail Limited. 

Powergen Retail Ltd is authorised and regulated by the Financial Services 
Authority for the sale and service of general insurance products.

Registered addresses:

Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 
8LG.
Registered in England and Wales No: 3407430

Telephone +44 (0) 2476 42 4000
Fax +44 (0) 2476 42 5432