I need to get the difference in days between two dates in DB2. I tried a couple of different queries but nothing seems to be working. So basically what i need to get is something like this.
SELECT DAYS (CURRENT DATE) - DAYS (DATE(CHDLM)) FROM CHCART00 WHERE CHSTAT = '05';
I know that if I remove CHDLM and specify a date like '2012-02-20' it works but I need to be able to run this against that field in the table. I also try this query that was given to me by a friend by is not working either.
select days (current date) - days (date(select concat(concat(concat(concat(left(a2.chdlm,4),'-'),substr(a2.chdlm,4,2)),'-'),right(a2.chdlm,2))) from sysibm.sysdummy1 a1, chcart00 a2 where chstat = '05';
Please any help will be greatly appreciate it. Thanks
This topic has been locked.
2 replies Latest Post - 2012-04-02T15:34:12Z by stevewatson
Pinned topic Calculating how many days are between two dates in DB2?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-04-02T15:34:12Z at 2012-04-02T15:34:12Z by stevewatson
B.Hauser 1000007U1D250 PostsACCEPTED ANSWER
Re: Calculating how many days are between two dates in DB2?2012-03-02T19:14:46Z in response to SystemAdminHi,
I think this one is easier (assumed your date is CHAR(8) in the format YYYYMMDD):
Select Days(Current_Date) - Days(CHDLM concat '000000'),
Days(Current_Date) - Days(Timestamp_Format(CHDLM, 'YYYYMMDD'))