On this page

Show all

Help Center/ GaussDB(DWS)/ Standard Data Warehouse (8.1.3.x)/ GaussDB(DWS) Stored Procedure/ Converting Data Types in GaussDB(DWS) Stored Procedures

Converting Data Types in GaussDB(DWS) Stored Procedures

Updated on 2024-12-19 GMT+08:00

Certain data types in the database support implicit data type conversions, such as assignments and parameters invoked by functions. For other data types, you can use the type conversion functions provided by GaussDB(DWS), such as the CAST function, to forcibly convert them.

Table 1 lists common implicit data type conversions in GaussDB(DWS).

NOTICE:

The valid value range of DATE supported by GaussDB(DWS) is from 4713 B.C. to 294276 A.D.

Table 1 Implicit data type conversions

Raw Data Type

Target Data Type

Remarks

CHAR

VARCHAR2

-

CHAR

NUMBER

Raw data must consist of digits.

CHAR

DATE

Raw data cannot exceed the valid date range.

CHAR

RAW

-

CHAR

CLOB

-

VARCHAR2

CHAR

-

VARCHAR2

NUMBER

Raw data must consist of digits.

VARCHAR2

DATE

Raw data cannot exceed the valid date range.

VARCHAR2

CLOB

-

NUMBER

CHAR

-

NUMBER

VARCHAR2

-

DATE

CHAR

-

DATE

VARCHAR2

-

RAW

CHAR

-

RAW

VARCHAR2

-

CLOB

CHAR

-

CLOB

VARCHAR2

-

CLOB

NUMBER

Raw data must consist of digits.

INT4

CHAR

-

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback