Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-03001 -- GAUSS-03100/ GAUSS-03021 -- GAUSS-03030
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-03021 -- GAUSS-03030

GAUSS-03021: "interval units '%s' not recognized"

SQLSTATE: 22023

Description: The interval type does not have the time unit.

Solution: Ensure that the input parameter is valid.

GAUSS-03022: "could not convert to time zone '%s'"

SQLSTATE: 22023

Description: A specified time zone cannot be converted to.

Solution: Ensure that the input parameter is valid. For details about the data value range, see "Data Types" in the SQL Syntax.

GAUSS-03023: "time zone '%s' not recognized"

SQLSTATE: 22023

Description: The time zone to be converted cannot be recognized.

Solution: Ensure that the input parameter is valid.

GAUSS-03024: "interval time zone '%s' must not specify month"

SQLSTATE: 22023

Description: A specified month is set for the time zone of the interval type.

Solution: Ensure that the input parameter is valid. For details about the data value range, see "Data Types" in the SQL Syntax.

GAUSS-03025: "the format is not correct"

DETAIL: "invalid date length "xxx", must between 8 and 10."

SQLSTATE: 0A000

Description: The input data is empty or the format is incorrect.

Solution: Check the input data.

GAUSS-03026: "the format of is not correct"

DETAIL: "There are "2" but not only 1 space in the string "xxx"."

SQLSTATE: 0A000

Description: The input string has an extra space, which is determined as an invalid format.

Solution: Check the input data.

GAUSS-03027: "the format is not correct!"

DETAIL: XXX XXX

SQLSTATE: 0A000

Description: The date format is incorrect.

Solution: Locate the error cause based on the DETAIL information. For details about the data value range, see "Data Types" in the SQL Syntax.

GAUSS-03028: "the year is invalid"

SQLSTATE: 0A000

Description: The year value is invalid.

Solution: Ensure that the input year value contains four digits.

GAUSS-03029: "the month is invalid!"

SQLSTATE: 0A000

Description: The month value is invalid.

Solution: Ensure that the input month value contains two digits.

GAUSS-03030: "the format is not correct\n"

DETAIL: "Time string "" format wrong, only "hh:mi:ss" is supported."

SQLSTATE: 0A000

Description: More than two separators are found in time strings, which is an invalid format.

Solution: Ensure that the input data is valid. For details about the data value range, see "Data Types" in the SQL Syntax.