Get the difference in date

prasanthi mathireddi · New User Joined: 19 Jun 2008 Posts: 2 Location: chennai

Hi,

I need to find out the difference between two dates(YYYY-MM-DD) in cobol-db2 program.
Output should also needed in Date format(YYYY-MM-DD).

EX: If input dates are 2008-06-20 and 2005-05-01 which i am getting it from query , i need to find out the difference between two dates as 0001-01-19.

Thanks,
Prasaha

Suresh Ponnusamy · Posted: Fri Jun 20, 2008 12:36 am

How the difference between 2008-06-20 and 2005-05-01 will be
0001-01-19?

How did arrive this result?

To find out the difference use the below query.

SELECT DATE(DATE('2008-06-20') - DATE('2005-05-01'))
FROM SYSIBM.SYSDUMMY1;;

I don't understand what you are going to achieve with this (Difference between 2 dates in date format).

ascelepius · New User Joined: 16 Jun 2008 Posts: 35 Location: bangalore

Well as Suresh has pointed out, the result 0001-01-19 from the difference between 2008-06-20 and 2005-05-01 seems illogical.

As far finding the difference between 2 dates(as an integer) go, the std SQL would be,

stodolas · Posted: Fri Jun 20, 2008 7:43 pm

I always point people to this article when they start to ask how to do date stuff with DB2. Does no one search Google for "db2 dates" before posting here?

www.ibm.com/developerworks/db2/library/techarticle/0211yip/0211yip3.html

prasanthi mathireddi · New User Joined: 19 Jun 2008 Posts: 2 Location: chennai

Thanks Suresh. Your query worked well but with little modifiation. i changed the query as below.

SELECT CHAR(DATE('2008-06-20') - DATE('2005-05-01'))
INTO :WS-OUT-DATE
FROM SYSIBM.SYSDUMMY1;

I got result WS-OUT-DATE as 00030119

Later i manipulated WS-OUT-DATE to reqired date format.

When i tried the below query

SELECT DATE(DATE('2008-06-20') - DATE('2005-05-01'))
FROM SYSIBM.SYSDUMMY1;

i didn't get correct result.

Thanks a lot for all who have gave reply for my post.

the_gautam · Posted: Sat Jun 21, 2008 6:28 am