====== DATE Function - PL/HQL Reference======

DATE function converts an expression to DATE data type.

**Syntax**:

<code language="sql">
DATE(expression); 
</code>

**Return Data Type:**

DATE

**Example:**

Convert a string and timestamp to DATE:

<code language="sql">
DATE('2015-03-12');
DATE('2015' || '-03-' || '12');
DATE(TIMESTAMP '2015-03-12 10:58:34.111');
</code> 

**Compatibility**: IBM DB2

**Version**: PL/HQL 0.03

See also:
  * [[date-literal|DATE Literal]]
  * [[timestamp-literal|TIMESTAMP Literal]]
  * [[timestamp-iso|TIMESTAMP_ISO Function]]