DATEPART function [Date and time]

DATEPART( date-part, timestamp-expression )

date-part The date part to be returned.
For a complete listing of allowed date parts, see Specifying date parts.
timestamp-expression The TIMESTAMP or TIMESTAMP WITH TIME ZONE value for which the part is to be returned.

INT

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

SQL/2008 Vendor extension.

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

DATEPART function [Date and time]

Syntax

Parameters

Returns

Remarks

Standards and compatibility

Example