Returns the value of part of a datetime value.

Syntax

DATEPART( date-part, date-expression )

Parameters

Returns

INT

Remarks

The date must contain the date-part field.

The numbers that correspond week days depend on the setting of the first_day_of_week option. By default Sunday=7.

See also

• first_day_of_week option [database]
• SET statement [T-SQL]

Standards and compatibility

Example

The following statement returns the value 5.

SELECT DATEPART( month , '1987/05/02' );

The following example creates a table, TableStatistics, and inserts into it the total number of sales orders per year as stored in the SalesOrders table:

CREATE TABLE TableStatistics ( 
   ID INTEGER NOT NULL DEFAULT AUTOINCREMENT, 
   Year INT, 
   NumberOrders INT );
INSERT INTO TableStatistics ( Year, NumberOrders )
   SELECT DATEPART( Year, OrderDate ), COUNT(*)
   FROM SalesOrders
   GROUP BY DATEPART( Year, OrderDate );