INVALID_INTERVAL_FORMAT error class

SQLSTATE: 22006

Error parsing ‘<input>’ to interval. Please ensure that the value provided is in a valid format for defining an interval. You can reference the documentation for the correct format.

ARITHMETIC_EXCEPTION

Uncaught arithmetic exception while parsing ‘<input>’.

DAY_TIME_PARSING

Error parsing interval day-time string: <msg>.

INPUT_IS_EMPTY

Interval string cannot be empty.

INPUT_IS_NULL

Interval string cannot be null.

INTERVAL_PARSING

Error parsing interval <interval> string.

INVALID_FRACTION

<unit> cannot have fractional part.

INVALID_PRECISION

Interval can only support nanosecond precision, <value> is out of range.

INVALID_PREFIX

Invalid interval prefix <prefix>.

INVALID_UNIT

Invalid unit <unit>.

INVALID_VALUE

Invalid value <value>.

MISSING_NUMBER

Expect a number after <word> but hit EOL.

MISSING_UNIT

Expect a unit name after <word> but hit EOL.

SECOND_NANO_FORMAT

Interval string does not match second-nano format of ss.nnnnnnnnn.

TIMEZONE_INTERVAL_OUT_OF_RANGE

The interval value must be in the range of [-18, +18] hours with second precision.

UNKNOWN_PARSING_ERROR

Unknown error when parsing <word>.

UNMATCHED_FORMAT_STRING

Interval string does not match <intervalStr> format of <supportedFormat> when cast to <typeName>: <input>.

UNMATCHED_FORMAT_STRING_WITH_NOTICE

Interval string does not match <intervalStr> format of <supportedFormat> when cast to <typeName>: <input>. Set “spark.sql.legacy.fromDayTimeString.enabled” to “true” to restore the behavior before Spark 3.0.

UNRECOGNIZED_NUMBER

Unrecognized number <number>.

UNSUPPORTED_FROM_TO_EXPRESSION

Cannot support (interval ‘<input>’ <from> to <to>) expression.