openGauss type conversion function to_char(numeric/smallint/integer/bigint/double precision/real[, fmt])

to_char(numeric/smallint/integer/bigint/double precision/real[, fmt])

Description: Convert an integer or floating point value to a string in the specified format.

The optional parameter fmt can be of the following categories: decimal characters, "grouping" characters, plus and minus signs and currency symbols. Each category can have different templates, and templates can be reasonably combined. Common templates are: 9, 0, , (thousand separator), . (decimal point).
Templates can have modifiers like FM, but FM does not suppress 0s specified by template 0 and output.
To convert a value of type integer to a string corresponding to the hexadecimal value, use the template X or x.
Return value type: varchar

Example:
openGauss=# SELECT to_char(1485,'9,999');

to_char

1,485
(1 row)

openGauss=# SELECT to_char( 1148.5,'9,999.999');

to_char

1,148.500
(1 row)

openGauss=# SELECT to_char(148.5,'990999.909');

to_char

0148.500

(1 row)
Copy after login

openGauss=# SELECT to_char(123,'XXX');

to_char

7B
(1 row)