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:
* [[date-literal|DATE Literal]]
* [[timestamp-literal|TIMESTAMP Literal]]
* [[timestamp-iso|TIMESTAMP_ISO Function]]