On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-03301 -- GAUSS-03400/ GAUSS-03361 -- GAUSS-03370

GAUSS-03361 -- GAUSS-03370

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

View PDF

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.

Parent topic: GAUSS-03301 -- GAUSS-03400

Previous topic: GAUSS-03351 -- GAUSS-03360

Next topic: GAUSS-03371 -- GAUSS-03380

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel