SQL - DATEPART

Summary: in this tutorial, you will learn how to use the SQL Server DATEPART() function to extract a part of a date.

SELECT DATEPART(YEAR, '12:10:30.123') 

      ,DATEPART(MONTH, '12:10:30.123') 

      ,DATEPART(DAY, '12:10:30.123') 

      ,DATEPART(DAYOFYEAR, '12:10:30.123') 

      ,DATEPART(WEEKDAY, '12:10:30.123'); 

DECLARE @t TIME = '12:10:30.123';  

SELECT DATEPART(year, @t); 

SELECT DATEPART(Millisecond, '00:00:01.1234567'); -- Returns 123 

SELECT DATEPART(Microsecond, '00:00:01.1234567'); -- Returns 123456 

SELECT DATEPART(Nanosecond,  '00:00:01.1234567'); -- Returns 123456700 

SELECT DATEPART(WW,GETDATE())

SELECT DATEPART(DAY,GETDATE())

SELECT DATEPART(WEEKDAY,GETDATE())

SELECT DATEPART(DAYOFYEAR,GETDATE())

SELECT DATEPART(YEAR,GETDATE())

SELECT DATEPART(QUARTER,GETDATE())

SELECT DATEPART(MONTH,GETDATE())

SELECT DATEPART(HOUR,GETDATE())

SELECT DATEPART(MINUTE,GETDATE())

SELECT DATEPART(SECOND,GETDATE())

SELECT CONVERT(DATE, getdate())