DATEDIFF

Ikki sana qiymati orasidagi farqni yillarda qaytaring:

SELECT DATEDIFF(year, '2017/08/25', '2011/08/25') AS DateDiff;

Ta’rif va qo‘llanilishi

DATEDIFF() funksiyasi ikki sana orasidagi farqni butun son sifatida qaytaradi.

DATEDIFF(interval, date1, date2)

Parametr	Tavsif
interval	Required. The part to return. Can be one of the following values: year, yyyy, yy = Year quarter, qq, q = Quarter month, mm, m = month dayofyear = Yilning kuni day, dy, y = Day week, ww, wk = Week weekday, dw, w = Weekday hour, hh = hour minute, mi, n = Minute second, ss, s = Second millisecond, ms = Millisecond
date1, date2	Majburiy. O‘rtasidagi farqni hisoblash uchun ikki sana

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

Ikki sana qiymati orasidagi farqni oylarda qaytaring:

SELECT DATEDIFF(month, '2017/08/25', '2011/08/25') AS DateDiff;

Ikki sana qiymati orasidagi farqni soatlarda qaytaring:

SELECT DATEDIFF(hour, '2017/08/25 07:00', '2017/08/25 12:45') AS DateDiff;

Yutuqlaringizni kuzating – bu bepul!