DATE_DIFF - Find Time Interval between two dates in Year, Months or Days or in Hours in Informatica

Syntax
DATE_DIFF( date1, date2, date_format)


Example: The following expressions return the number of days between the
DATE_PROMISED and the DATE_SHIPPED ports:
DATE_DIFF DATE_DIFF ( DATE_PROMISED, DATE_SHIPPED, 'D' )
DATE_DIFF DATE_DIFF ( DATE_PROMISED, DATE_SHIPPED, 'DD' )

DATE_PROMISED         DATE_SHIPPED         RETURN VALUE
Jan 1 1997 12:00:00AM     Mar 29 1997 12:00:00PM         -87.5
Mar 29 1997 12:00:00PM     Jan 1 1997 12:00:00AM          87.5