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

Dates overview

Dates overview

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 machine that hosts
Data Integration
.
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.

0 COMMENTS

We’d like to hear from you!