BIP2463

Severity

20 : Error

Message

Error casting the character string <insert_1> to an interval.

Explanation

A character string must have the format 'INTERVAL '<field values>' <qualifier>' or '<field values>' for it to be cast to an interval. Valid field values depend on the qualifier. For example, for a DAY TO SECOND interval the format is '[<sign>]<day> <hour>:<minute>:<second>'. Note that all except the first field are required to have two digits. Seconds however may also have a fractional part.

Response

Ensure the string being cast is formatted correctly. Consult the the documentation for more information concerning field values and qualifiers.