You cannot convert datatypes in the Date/Interval category to datatypes in the Approximate Numeric, Integral Numeric, Decimal Numeric, or Binary/Other categories. As shown in the table below, you can convert datatypes in the Date/Interval category to datatypes in the Character and Date/Interval categories. Date/Interval describes the string formats.