Date different in DB2

[mandyli]

What is data diff function in DB2 or Datastage?

[vbeeram]

Hi,

What exactly u want the Output in number of days OR in date format?

[mandyli]

I want to find different no of days and no of month

[lakshmipriya]

For number of days u can use the juliandays function

convert both the dates for which u have to find the difference to juliandayfromdate

For number of months

use the function monthfromdate

[mandyli]

Thanks I will try