Date

Returns only the date portion of the date-time column. The time is truncated, not rounded.

Syntax

Date(Date/Time)

Where:

Date/Time is the input date or timestamp.

For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions.

Example

Input is the date 2004-07-29; output is the date 2004-07-29.

Input is the date-time 2004-07-29 02:00:00; output is the date 2004-07-29.