DATEPART

Misol

Sananing ko‘rsatilgan qismini qaytaring:

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

O‘zingiz sinab ko‘ring »

Ta’rif va qo‘llanilishi

DATEPART() funksiyasi sananing ko‘rsatilgan qismini qaytaradi.

Bu funksiya natijani butun qiymat sifatida qaytaradi.

Sintaksis

DATEPART(interval, date)

Parametr qiymatlari

Parametr	Tavsif
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 = Yilning kuni day, dd, d = Oyning kuni 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	Majburiy. Foydalanish sanasi. Quyidagi ma’lumotlar turlaridan biri bo‘lishi mumkin: sana, datetime, datetimeoffset, datetime2, smalldatetime yoki time

Parametr

Tavsif

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 = Yilning kuni
day, dd, d = Oyning kuni
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

Majburiy. Foydalanish sanasi. Quyidagi ma’lumotlar turlaridan biri bo‘lishi mumkin: sana, datetime, datetimeoffset, datetime2, smalldatetime yoki time

Texnik tafsilotlar

Qaytariladigan qiymat turi:	int
Qo‘llab-quvvatlaydigan tizimlar:	SQL Server (2008 dan boshlab), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse