Updated on 2024-03-15 GMT+08:00

GAUSS-03361 -- GAUSS-03370

GAUSS-03361: "source string too short for '%s' formatting field"

SQLSTATE: 22007

Description: The date format is incorrect. The length of the source string is shorter than the length to be read.

Solution: Use the "FM" modifier if the source string does not have a fixed length.

GAUSS-03362: "invalid value '%s' for '%s'"

SQLSTATE: 22007

Description: The date format is incorrect. Partial characters of the string cannot be parsed.

Solution: Modify the format of the string to be converted to a date and ensure that the string is in the valid date format. If the string does not have a fixed length, use the "FM" modifier.

GAUSS-03363: "value for '%s' in source string is out of range"

SQLSTATE: 22008

Description: The date format is incorrect. The string value is out of range.

Solution: Change the string value based on the prompt and ensure that the string value is within the valid range.

GAUSS-03364: "character does not match format string"

SQLSTATE: 22007

Description: Internal system error.

Solution: Contact technical support.

GAUSS-03365: "input length of format 'US'/'us'/'FF'/'ff' must between 0 and 6"

SQLSTATE: 22008

Description: The date value is out of range. The length of "US/us/FF/ff" format must be between 0 and 6.

Solution: Change the format length and ensure that the format is between 0 and 6.

GAUSS-03366: "'TZ'/'tz' format patterns are not supported in to_date"

SQLSTATE: 0A000

Description: The date in the "TZ/tz" format is not supported.

Solution: Modify the date format.

GAUSS-03367: "invalid input string for 'Y,YYY'"

SQLSTATE: 22007

Description: The input string fails to meet the date format requirement.

Solution: Ensure that the input string is in Y,YYY format.

GAUSS-03368: "invalid data for match in date string"

SQLSTATE: 22007

Description: The date format is incorrect. The data for match in a date string is invalid.

Solution: Use valid string text to query the match.

GAUSS-03369: "invalid data for '%s = %d' ,value must be %s"

SQLSTATE: 22008

Description: The date format is incorrect. The input data is inconsistent with the specified value.

Solution: Specify the data based on the specified value.

GAUSS-03370: " seconds of minute conflicts with seconds in day"

SQLSTATE: 22007

Description: The date format is incorrect. The number of minutes is inconsistent with the number of seconds in a day.

Solution: Modify the time format.