1. Home

SQL Server DATEPART() Function

Return a specified part of a date

Definition and Usage

The DATEPART() function returns a specified part of a date.

This function returns the result as an integer value.

Syntax

DATEPART(interval, date)

Parameter Values

Parameter Description
interval Required. The part of the date argument to return. Can be one of the following values:
  • year, yyyy, yy = Year
  • quarter, qq, q = Quarter
  • month, mm, m = month
  • dayofyear, dy, y = Day of the year
  • day, dd, d = Day of the month
  • week, ww, wk = Week
  • weekday, dw, w = Weekday
  • hour, hh = hour
  • minute, mi, n = Minute
  • second, ss, s = Second
  • millisecond, ms = Millisecond
  • microsecond, mcs = Microsecond
  • nanosecond, ns = Nanosecond
  • tzoffset, tz = Timezone offset
  • iso_week, isowk, isoww = ISO week
date Required. The date to use. Can be one of the following data types: date, datetime, datetimeoffset, datetime2, smalldatetime, or time

Technical Details

Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

More Examples

Example

Return a specified part of a date:

SELECT DATEPART(yy, '2017/08/25') AS DatePartInt;

Example

Return a specified part of a date:

SELECT DATEPART(month, '2017/08/25') AS DatePartInt;

Example

Return a specified part of a date:

SELECT DATEPART(hour, '2017/08/25 08:36') AS DatePartInt;

Example

Return a specified part of a date:

SELECT DATEPART(minute, '2017/08/25 08:36') AS DatePartInt;

Categories

HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

Contact US