to_char(timestamp, format text)
Advertisements
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.
apache_tajo_datetime_functions.htm
Advertisements