MVSFORUMS.com

shekar123 · SELECT DATE('2004-08-16') - DATE('1976-01-01') FROM SYSIBM.SYSDUMMY1; 280715

Hai All,

I am looking for a query which would tell me the date of my retirement Crying or Very sad

assuming that when i joined the company on 2004-08-16 and my DOB being 1976-01-01 ,my age was 28 years 7 months and 15 days .

kolusu · Posted: Thu Jul 27, 2006 8:12 pm Post subject:

shekar123,

Try this untested sql

shekar123 · Posted: Thu Jul 27, 2006 9:09 pm Post subject:

Kolusu,

You always prove that you are simply great and no need to test the query anywhere as it fetches all the expected values.Thanks. Very Happy

_________________
Shekar
Grow Technically

coolman · Posted: Fri Jul 28, 2006 9:57 am Post subject:

Kolusu,

If RETIREMENT DATE is 58 YEARS, then why have such a complex calculation with the JOIN DATE AND SERVICE DATE

Say for Example, Shekar123's birthday was 01-01-1976 and another person Chris's Birthday was 01-01-2000

So, Shekar would retire by 1976 + 58 = 2034 and Chris would retire by 2058

Why do we have to bring the JOIN DATE into the picture at all?

So, the query would be :

shekar123 · Posted: Fri Jul 28, 2006 10:07 am Post subject:

Coolman,

If you read my requirement , my query was to find out the retirment date if my company has limit to 58 years and to know how many years i worked.If my DOB was 1976-01-01 ,but i can join any year and my joining date would matter to calculate the number of years worked and the to know the retirement date.Hope i am clear.
_________________
Shekar
Grow Technically

kolusu · Posted: Fri Jul 28, 2006 10:07 am Post subject:

coolman · Posted: Fri Jul 28, 2006 10:12 am Post subject:

Shekar123,

You didn't get my point. JOINing date is immaterial when it comes to calculating the RETIREMENT DATE - JOINING date is required only when calculating the years of service at the company.

Hope this helps...
________
e cigarette

shekar123 · Posted: Fri Jul 28, 2006 11:42 am Post subject:

coolman,

You need to know the Joining date to know the number of years worked in the company.Probably i did not put in the proper way in my previous post.
_________________
Shekar
Grow Technically