d27m11y d27m11y
asked on
Comparision of dates in DB2
I have a query which says
select
ACCNO,
INSERTEDDATE AS LOADDATE,
ENDDATE,
date(A.INSERTEDDATE) AS LOADDATE2,
DATE(B.ENDDATE) AS ENDDATE2
name,
number
from
A,B
WHERE
A.ACCNO = B.ACCNO AND
DATE() > (INSERTEDDATE) + 5
AND DATE() < (A.ENDDATE2 -45)
I would like to what is the function to compare dates in DB2
select
ACCNO,
INSERTEDDATE AS LOADDATE,
ENDDATE,
date(A.INSERTEDDATE) AS LOADDATE2,
DATE(B.ENDDATE) AS ENDDATE2
name,
number
from
A,B
WHERE
A.ACCNO = B.ACCNO AND
DATE() > (INSERTEDDATE) + 5
AND DATE() < (A.ENDDATE2 -45)
I would like to what is the function to compare dates in DB2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.