This will also work,
date(pending_date) < date(current_timestamp - 1 day)
Computer says 'No'..
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Tuesday, July 05, 2005 4:10 PM
To: ADSM-L@VM.MARIST.EDU
Subject: incompat
5, 2005 4:10 PM
To: ADSM-L@VM.MARIST.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 fi
I think the problem is that you are mixing "date" data with "timestamp"
data (the latter includes date and time). Try changing this:
... and date(pending_date) < (current_timestamp - 1 day) and ...
to this:
... and date(pending_date) < (date(current_timestamp) - 1 day) and ...
Regards,
Andy
A
Sent: Tuesday, 05 July, 2005 17:10
To: ADSM-L@VM.MARIST.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
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. Tha
