to_char(timestamp, format text)

Let us now check the to_char( timestamp,format) function with the following query.

Query

default> select to_char(current_timestamp,'dd-mm-yyyy') as convert_char;  

Result

The above query will generate the following result.

convert_char 
------------------------------- 
11-08-2016 

The query converts timestamp to character format.