Apache Tajo - to_char(int,text)

Let us now check the to_char(int,text) function with the following query.

Query

default> select to_char(2,'011') as char_conversion; 

Result

The above query will generate the following result.

char_conversion 
------------------------------- 
211 

The above query performs character conversion. Here, the integer 2 is converted to string ‘011’. The result for this conversion is 211.