Concepts to Know : Supported Files, Formats, and Text Types : Supported Text Types : Date, Time, and Interval Types
 
Share this page                  
Date, Time, and Interval Types
These types map to the date, time, and timestamp token types of DataFlow. The default text types associated with these token types are ISO_DATE, ISO_TIMEOFDAY, and ISO_TIMESTAMP respectively.
Text Type
Description
ISO_DATE
A date value represented in ISO-8601 format
FORMATTED_DATE
A date value represented using a specified DateFormat
ISO_TIMESTAMP
A timestamp value represented in ISO-8601 format
FORMATTED_TIMESTAMP
A timestamp value represented using a specified DateFormat
ISO_TIMEOFDAY
A time value represented in ISO-8601 format
FORMATTED_TIMEOFDAY
A time value represented using a specified DateFormat
JAVA_DURATION
A time interval represented in ISO-8601 format
FORMATTED_DURATION
A time interval represented using a specified IntervalFormatting
JAVA_PERIOD
A date interval represented in ISO-8601 format
FORMATTED_PERIOD
A date interval represented using a specified IntervalFormatting