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

Dates Overview

Dates Overview

The transformation language provides a set of date functions and built-in date variables to perform transformations on dates. With the date functions, you can 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 a date function.
Use date variables to capture the current date or session start time on the node hosting the
PowerCenter Integration Service
.
The transformation language also provides the following sets of format strings:
  • Date format strings.
    Use with date functions to specify the parts of a date.
  • TO_CHAR format strings.
    Use to specify the format of the return string.
  • TO_DATE and IS_DATE format strings.
    Use to specify the format of a string you want to convert to a date or test.