Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

Date Functions

Date Functions

The transformation language includes a group of date functions to round, truncate, or compare dates, extract one part of a date, or perform arithmetic on a date.
You can pass any value with a date datatype to any of the date functions. However, if you want to pass a string to a date function, you must first use the TO_DATE function to convert it to a transformation Date/Time datatype.
The transformation language includes the following date functions:
  • ADD_TO_DATE
  • DATE_COMPARE
  • DATE_DIFF
  • GET_DATE_PART
  • IS_DATE
  • LAST_DAY
  • MAKE_DATE_TIME
  • MAX
  • MIN
  • ROUND(Date)
  • SET_DATE_PART
  • SYSTIMESTAMP
  • TO_CHAR(Date)
  • TRUNC(Date)
Several of the date functions include a
format
argument. You must specify one of the transformation language format strings for this argument. Date format strings are not internationalized.
The Date/Time transformation datatype supports dates with precision to the nanosecond.