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>’.

INPUT_IS_EMPTY

Interval string cannot be empty.

INPUT_IS_NULL

Interval string cannot be null.

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.

UNKNOWN_PARSING_ERROR

Unknown error when parsing <word>.

UNRECOGNIZED_NUMBER

Unrecognized number <number>.