Apache Hive : HPL/SQL - DATE Function

Last updated: August 12, 2026

DATE function converts an expression to DATE data type.

Syntax:

DATE(expression);

Return Data Type:

DATE

Example:

Convert a string and timestamp to DATE:

DATE('2015-03-12');
DATE('2015' || '-03-' || '12');
DATE(TIMESTAMP '2015-03-12 10:58:34.111');

Compatibility: IBM DB2