DATEPART( date-part, timestamp-expression )

INT

For meaningful results timestamp-expression should contain the required date-part portion.

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

• first_day_of_week option
• SET statement [T-SQL]

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 );