ASA SQL Reference
SQL Functions
Alphabetical list of functions
Converts the expression into a date, and removes any hours, minutes or seconds.
DATE ( expression )
expression The value to be converted to date format. The expression is usually a string.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
The following statement returns the value 1999-01-02 as a date.
SELECT DATE( '1999-01-02 21:20:53' )