DATEPART (SQL Server Compact)
Returns an integer representing the specified datepart of the specified date.
The parameter that specifies the part of the date to return. For more information, see the "Remarks" section later in this topic.
An expression that returns a datetime value, or a value that can be implicitly converted to a datetime value. A date argument can also be a character string in a date format. Use the datetime data type only for dates after January 1, 1753. Store dates as character data for earlier dates. When entering datetime values, always enclose them in single quotation marks.
If you specify only the last two digits of the year, values less than or equal to the last two digits of the value of the two digit year cutoff configuration option are in the same century as the cutoff year. Values greater than the last two digits of the value of this option are in the century that precedes the cutoff year. For example, if the two digit year cutoff is 2049 (the default value), the '49' is interpreted as 2049 and '50' is interpreted as 1950. To avoid ambiguity, use four-digit years.
For more information about specifying dates, see datetime in Data Types.