DSXchange

Posted: **Wed Aug 14, 2002 12:43 pm**

Hi Santosh,

you simple have to write a routine in DataStage, which does the work for you.

Wolfgang

Problem Description:

There is a age field in CCYY-MM-DD format.
I need to get the age field in months as numeric value.
Like a person can have age like, 200 months or 525 months and so on so on so forth.
If it getting calclated in decimal then I need to round off to get the whole number. The Database is DB2 and o/s AIX 4.3.Datastage is 5.2
How do I it? If someone would answer in detail, that would be great.

Thanks in advance

Santosh

Posted: **Mon Aug 19, 2002 8:59 am**

Problem Description:

There is a age field in CCYY-MM-DD format.
I need to get the age field in months as numeric value.
Like a person can have age like, 200 months or 525 months and so on so on so forth.
If it getting calclated in decimal then I need to round off to get the whole number. The Database is DB2 and o/s AIX 4.3.Datastage is 5.2
How do I it? If someone would answer in detail, that would be great.

Thanks in advance

Santosh

Posted: **Mon Aug 19, 2002 9:00 am**

Hi,

I don't quite understand your question. Is the person's age from the source in months or are you calculating the age to months and want to convert it to something else?

Lou

Problem Description:

There is a age field in CCYY-MM-DD format.
I need to get the age field in months as numeric value.
Like a person can have age like, 200 months or 525 months and so on so on so forth.
If it getting calclated in decimal then I need to round off to get the whole number. The Database is DB2 and o/s AIX 4.3.Datastage is 5.2
How do I it? If someone would answer in detail, that would be great.

Thanks in advance

Santosh

DSXchange

Date Arithmetic