DateDiff

Ikki sana orasidagi farqni yillarda qaytarish:

SELECT DateDiff("yyyy", #13/01/1998#, #09/05/2017#);

Ta’rif va qo‘llanilishi

DateDiff() funksiyasi ikki sana orasidagi farqni qaytaradi.

DateDiff(datepart, date1, date2, firstdayofweek, firstweekofyear)

Parametr	Tavsif
datepart	Required. The part to return. Can be one of the following values: yyyy = Year q = Quarter m = month y = Yilning kuni d = Day w = Weekday ww = Week h = hour n = Minute s = Second
date1 va date2	Majburiy. O‘rtasidagi farqni hisoblash uchun ikki sana
firstdayofweek	Optional. Specifies the first day of the week. Can be one of the following values: 0 = NLS API sozlamasidan foydalanish 1 = Yakshanba (bu standart qiymat) 2 = Monday 3 = Tuesday 4 = Wednesday 5 = Thursday 6 = Friday 7 = Saturday
firstdayofyear	Optional. Specifies the first week of the year. Can be one of the following values: 0 = NLS API sozlamasidan foydalanish 1 = 1-yanvarni o‘z ichiga olgan birinchi haftadan foydalanish (standart) 2 = Yildagi kamida 4 kuni bo‘lgan birinchi haftadan foydalanish 3 = Yilning birinchi to‘liq haftasidan foydalanish

Qo‘llab-quvvatlaydigan tizimlar:	MS Access 2000 versiyasidan boshlab

Ikki sana orasidagi farqni oylarda qaytarish:

SELECT DateDiff("m", #13/01/1998#, #09/05/2017#);

Belgilangan sana va bugungi kun o‘rtasidagi farqni kunlarda qaytaring:

SELECT DateDiff("d", #13/01/1998#, Date());

Yutuqlaringizni kuzating – bu bepul!