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.