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

RR Format String

RR Format String

The transformation language provides the RR format string to convert strings with two-digit years to dates. Using TO_DATE and the RR format string, you can convert a string in the format MM/DD/RR to a date. The RR format string converts data differently depending on the current year.
  • Current Year Between 0 and 49.
    If the current year is between 0 and 49 (such as 2003) and the source string year is between 0 and 49, the
    PowerCenter Integration Service
    returns the current century plus the two-digit year from the source string. If the source string year is between 50 and 99, the Integration Service returns the previous century plus the two-digit year from the source string.
  • Current Year Between 50 and 99.
    If the current year is between 50 and 99 (such as 1998) and the source string year is between 0 and 49, the
    PowerCenter Integration Service
    returns the next century plus the two-digit year from the source string. If the source string year is between 50 and 99, the
    PowerCenter Integration Service
    returns the current century plus the specified two-digit year.
The following table summarizes how the RR format string converts to dates:
Current year
Source year
RR Format String Returns
0-49
0-49
Current century
0-49
50-99
Previous century
50-99
0-49
Next century
50-99
50-99
Current century

0 COMMENTS

We’d like to hear from you!