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
[EMAIL PROTECTED]
********************************
