DATE function [Date and time]

Function

Converts the expression into a date, and removes any hours, minutes, or seconds.

Syntax

DATE ( expression )

Parameters

expression The value to be converted to date format. The expression is usually a string.

Example

The following statement returns the value 1988-11-26 as a date.

SELECT DATE( '1988-11-26 21:20:53' ) FROM iq_dummy

Standards and compatibility

SQL92 Vendor extension.

Sybase Not supported by Adaptive Server Enterprise.