Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions

Transformation Language Reference

Transformation Language Reference

Default Date Format

Default Date Format

The
Data Integration Service
uses a default date format to store and manipulate strings that represent dates. To specify the default date format, enter a date format in the DateTime Format String attribute in the data viewer configuration. By default, the date format is MM/DD/YYYY HH24:MI:SS.US.
Because Informatica stores dates in binary format, the
Data Integration Service
uses the default date format when you perform the following actions:
  • Convert a date to a string by connecting a date/time port to a string port.
    The
    Data Integration Service
    converts the date to a string in the date format defined in the data viewer configuration.
  • Convert a string to a date by connecting a string port to a date/time port.
    The
    Data Integration Service
    expects the string values to be in the date format defined by the data viewer configuration. If an input value does not match this format, or if it is an invalid date, the
    Data Integration Service
    skips the row. If the string is in this format, the
    Data Integration Service
    converts the string to a date value.
  • Use TO_CHAR(date, [format_string]) to convert dates to strings.
    If you omit the format string, the
    Data Integration Service
    returns the string in the date format defined in the data viewer configuration. If you specify a format string, the
    Data Integration Service
    returns a string in the specified format.
  • Use TO_DATE(date, [format_string]) to convert strings to dates.
    If you omit the format string, the
    Data Integration Service
    expects the string in the date format defined in the data viewer configuration. If you specify a format string, the
    Data Integration Service
    expects a string in the specified format.
The default date format of MM/DD/YYYY HH24:MI:SS.US consists of:
  • Month (January = 01, September = 09)
  • Day (of the month)
  • Year (expressed in four digits, such as 1998)
  • Hour (in 24-hour format, for example, 12:00:00AM = 0, 1:00:00AM = 1, 12:00:00PM = 12, 11:00:00PM = 23)
  • Minutes
  • Seconds
  • Microseconds

0 COMMENTS

We’d like to hear from you!