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.
Data Integration recognizes leap years and accepts dates between Jan. 1, 1753 00:00:00 AD and Dec. 31, 9999 23:59:59 AD.
Note: Data Integration uses the Date/Time datatype to specify date values. You can only use the date functions on datetime values.