DatePart

Belgilangan sananing yil qismini qaytaring:

SELECT DatePart("yyyy", #09/05/2017#);

Ta’rif va qo‘llanilishi

DatePart() funksiyasi sananing ko‘rsatilgan qismini butun son sifatida qaytaradi.

DatePart(datepart, date, firstdayofweek, firstweekofyear)

Parametr	Tavsif
datepart	Required. The date 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
date	Majburiy. Baholanadigan sana qiymati
firstdayofweek	Optional. Specifies the first day of the week. Can be one of the following values: 0 = NLS API sozlamasidan foydalanish 1 = Sunday (default) 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

Belgilangan sananing oy qismini qaytaring:

SELECT DatePart("m", #09/05/2017#);

Bugungi sananing hafta kunini qaytarish:

SELECT DatePart("w", Date());

Yutuqlaringizni kuzating – bu bepul!