Apache Hive : HPL/SQL - TO_CHAR Function

Last updated: August 12, 2026

Apache Hive : HPL/SQL - TO_CHAR Function

TO_CHAR function converts an expression to string.

Syntax:

TO_CHAR(expression); 

Return Type:

STRING

Example:

TO_CHAR(CURRENT_DATE); 

Compatibility: Oracle, IBM DB2 and Teradata

See also: