DATEPART

The DATEPART function returns a date/time value that is normalized to the start of the day, for use in comparisons with other date/time values.

To get a string that contains the date only, use:

TEXT(MONTH(date_modified))+'/'+TEXT(DAY(date_modified))+'/'+TEXT(YEAR(date_modified))

Syntax

DATEPART('<tt>[[dString]]</tt>'))

Return

A date in the format defined by Date Format

Examples

DATEPART('04/22/2009 03:15 am') ='04/22/2009 12:00:00 AM'
 
DATEPART(DATE ('2009', '04', '22', '03', '15',  '00')) ='04/22/2009 12:00:00 AM'