DATE( expression )

DATE

• CURRENT TIME special value
• CURRENT TIMESTAMP special value
• CURRENT UTC TIMESTAMP special value
• DATE data type
• DATETIME data type
• DATETIME function [Date and time]
• DATETIMEOFFSET data type
• Expressions
• GETDATE function [Date and time]
• ISDATE function [Data type conversion]
• NOW function [Date and time]
• SMALLDATETIME data type
• TIME data type
• TIMESTAMP special value
• TIMESTAMP data type
• UTC TIMESTAMP special value

The following statement returns the value 1999-01-02 as a date.

SELECT DATE( '1999-01-02 21:20:53' );

The following statement returns the create dates of all the objects listed in the SYSOBJECT system view:

SELECT DATE( creation_time ) FROM SYSOBJECT;