Converts the expression into a date, and removes any hours, minutes, or seconds.
DATE ( expression )
Parameter
Description
expression
The value to be converted to date format. The expression is usually a string.
DATE
The following statement returns the value 1988-11-26 as a date.
SELECT DATE( '1988-11-26 21:20:53' ) FROM iq_dummy
SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not supported by Adaptive Server Enterprise.