GitHubContribute in GitHub: Edit online

datetime_part()

Extracts the requested date part as an integer value.

Deprecated aliases: datepart()

Syntax

datetime_part(part,datetime)

Parameters

Name Type Required Description
part string ✓ Measurement of time to extract from date. See possible values.
date datetime ✓ The full date from which to extract part.

Possible values of part

  • Year
  • Quarter
  • Month
  • week_of_year
  • Day
  • DayOfYear
  • Hour
  • Minute
  • Second
  • Millisecond
  • Microsecond
  • Nanosecond

Returns

An integer representing the extracted part.

NOTE

week_of_year returns an integer which represents the week number. The week number is calculated from the first week of a year, which is the one that includes the first Thursday.

Example

```kusto

  print 
  year = datetime_part("year",datetime(2017-10-30 01:02:03.7654321)),
  quarter = datetime_part("quarter",datetime(2017-10-30 01:02:03.7654321)),
  month = datetime_part("month", datetime(2017-10-30 01:02:03.7654321)),
  weekOfYear = datetime_part("week_of_year",datetime(2017-10-30 01:02:03.7654321)),
  day = datetime_part("day",datetime(2017-10-30 01:02:03.7654321)),
  dayOfYear = datetime_part("dayOfYear",datetime(2017-10-30 01:02:03.7654321)),
  hour = datetime_part("hour",datetime(2017-10-30 01:02:03.7654321)),
  minute = datetime_part("minute",datetime(2017-10-30 01:02:03.7654321)),
  second = datetime_part("second", datetime(2017-10-30 01:02:03.7654321)),
  millisecond = datetime_part("millisecond",datetime(2017-10-30 01:02:03.7654321)),
  microsecond = datetime_part("microsecond",datetime(2017-10-30 01:02:03.7654321)),
  nanosecond = datetime_part("nanosecond", datetime(2017-10-30 01:02:03.7654321))


### Results

  |year|quarter|month|weekOfYear|day|dayOfYear|hour|minute|second|millisecond|microsecond|nanosecond  |
  |----|-------|-----|----------|---|---------|----|------|------|-----------|-----------|------------|
  |2017|4      |10   |44        |30 |303      |1   |2     |3     |765        |765432     |765432100   |

#### Note
`weekofyear` is an obsolete variant of `week_of_year` part. `weekofyear` was not ISO 8601 compliant; the first week of a year was defined as the week with the year's first Wednesday in it.
`week_of_year` is ISO 8601 compliant; the first week of a year is defined as the week with the year's first Thursday in it. [For more information], see [ISO 8601 week dates](https://en.wikipedia.org/wiki/ISO_8601#Week_dates).