Table of Contents

Search

  1. Preface
  2. Function reference
  3. Constants
  4. Operators
  5. Dates
  6. Functions
  7. System variables
  8. Datatype reference

Function Reference

Function Reference

Understanding date arithmetic

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.
Data Integration
uses the Date/Time datatype to specify date values. You can only use the date functions on datetime values.

0 COMMENTS

We’d like to hear from you!