Data Type Functions and Operators¶
-
to_bin
(source int4)¶ Returns the binary representation of integer.
Parameters: source – source value Return type: text Example: select to_bin(22); > 10110
-
to_char
(source int8, format text)¶ Convert integer to string.
Parameters: - source – source value
- format – format
Return type: text
Example: select to_char(125, '00999'); > 00125
-
to_hex
(source int4)¶ Convert the argument to hexadecimal.
Parameters: source – source value Return type: text Example: select to_hex(15); > F