HPL/SQL is included to Apache Hive since version 2.0
HPL/SQL is included to Apache Hive since version 2.0
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
Version: PL/HQL 0.03
See also: