DSXchange • equivalent function for oracle "months_between" fu

Page 1 of 1

equivalent function for oracle "months_between" fu

Posted: Mon Feb 16, 2009 5:27 pm

by gsym

hey,

Is there a datastage euivalent function for oracle months_between function?

Thanks

Posted: Mon Feb 16, 2009 5:29 pm

by ray.wurlod

No.

The closest you can get without writing you own is DaysFromDateSince().

Thanks Ray

Posted: Tue Feb 17, 2009 10:45 am

by gsym

Thanks for the response Ray. After enrichment, Used a temp table to perform such functions.