Understanding Date Arithmetic
The transformation language provides built-in date functions so you can perform arithmetic on datetime values as follows:
- •ADD_TO_DATE. Add or subtract a specific portion of a date.
- •DATE_DIFF. Subtract two dates.
- •SET_DATE_PART. Change one part of a date.
You cannot use numeric arithmetic operators (such as + or -) to add or subtract dates.
Informatica Cloud recognizes leap years and accepts dates between Jan. 1, 1753 00:00:00 AD and Dec. 31, 9999 23:59:59 AD.
Note: Informatica Cloud uses the Date/Time datatype to specify date values. You can only use the date functions on datetime values.