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

Requirements

Requirements

Data Integration
expects the format of the TO_DATE string to meet the following conditions:
  • The format of the TO_DATE string must match the format string including any date separators. If it does not,
    Data Integration
    might return inaccurate values or skip the row. For example, if you pass the string ‘20200512’, representing May 12, 2020, to TO_DATE, you must include the format string YYYYMMDD. If you do not include a format string,
    Data Integration
    expects the string in the default date format MM/DD/YYYY HH24:MI:SS. Likewise, if you pass a string that does not match the format string,
    Data Integration
    returns an error and skips the row. For example, if you pass the string 2020120 to TO_DATE and include the format string YYYYMMDD,
    Data Integration
    returns an error and skips the row because the string does not match the format string.
  • The format string must always be enclosed within single quotation marks.
    By default,
    Data Integration
    uses the format string MM/DD/YYYY HH24:MI:SS. The format string is not case sensitive.

0 COMMENTS

We’d like to hear from you!