Error Messages Associated with SQLSTATE 22007

This topic lists the errors associated with the SQLSTATE 22007.

SQLSTATE 22007 Description

ERRCODE_INVALID_DATETIME_FORMAT

Error messages associated with this SQLState

ERROR 2171: AM/PM hour (value) must be between 1 and 12
ERROR 2364: Cannot calculate day of year without year information
ERROR 3439: Format string is invalid for an Interval value
ERROR 3535: Inconsistent use of year value and "BC"
ERROR 3647: Invalid day-of-week 'string'
ERROR 3679: Invalid input syntax for string: "string"
ERROR 3721: Invalid partition key
ERROR 3785: Invalid value for string: "value"

The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.