DateDiff

VBScript DateDiff funksiyasi

❮ To‘liq VBScript ma’lumotnomasi

DateDiff funksiyasi ikki sana orasidagi intervallar sonini qaytaradi.

Sintaksis

DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]])
Parametr Tavsif
interval Majburiy. date1 va date2 orasidagi farqni hisoblash uchun ishlatmoqchi bo‘lgan intervalingiz

Quyidagi qiymatlarni qabul qilishi mumkin:

  • yyyy - Yil
  • q - Chorak
  • m - Oy
  • y - Yilning kuni
  • d - Kun
  • w - Hafta kuni
  • ww - Yilning haftasi
  • h - Soat
  • n - Daqiqa
  • s - Soniya
date1,date2 Majburiy. Sana ifodalari. Hisoblashda foydalanmoqchi bo‘lgan ikki sanangiz
firstdayofweek Ixtiyoriy. Hafta kunini belgilaydi.

Quyidagi qiymatlarni qabul qilishi mumkin:

  • 0 = vbUseSystemDayOfWeek - National Language Support (NLS) API sozlamasidan foydalanish
  • 1 = vbSunday - Yakshanba (standart)
  • 2 = vbMonday - Dushanba
  • 3 = vbTuesday - Seshanba
  • 4 = vbWednesday - Chorshanba
  • 5 = vbThursday - Payshanba
  • 6 = vbFriday - Juma
  • 7 = vbSaturday - Shanba
firstweekofyear Ixtiyoriy. Yilning birinchi haftasini belgilaydi.

Quyidagi qiymatlarni qabul qilishi mumkin:

  • 0 = vbUseSystem - National Language Support (NLS) API sozlamasidan foydalanish
  • 1 = vbFirstJan1 - 1-yanvar kelgan haftadan boshlash (standart)
  • 2 = vbFirstFourDays - Yangi yilda kamida to‘rt kuni bo‘lgan haftadan boshlash
  • 3 = vbFirstFullWeek - Yangi yilning birinchi to‘liq haftasidan boshlash

Misollar

1-misol

2009-yil 31-yanvar va 2010-yil 31-yanvar orasidagi farq:

<% fromDate="31-Jan-09 00:00:00" toDate="31-Jan-10 23:59:00" response.write(DateDiff("yyyy",fromDate,toDate) & "<br />") response.write(DateDiff("q",fromDate,toDate) & "<br />") response.write(DateDiff("m",fromDate,toDate) & "<br />") response.write(DateDiff("y",fromDate,toDate) & "<br />") response.write(DateDiff("d",fromDate,toDate) & "<br />") response.write(DateDiff("w",fromDate,toDate) & "<br />") response.write(DateDiff("ww",fromDate,toDate) & "<br />") response.write(DateDiff("h",fromDate,toDate) & "<br />") response.write(DateDiff("n",fromDate,toDate) & "<br />") response.write(DateDiff("s",fromDate,toDate) & "<br />") %>

Yuqoridagi kodning natijasi quyidagicha bo‘ladi:

1 4 12 365 365 52 53 8783 527039 31622340
Misolni ko‘rsatish »

2-misol

Necha hafta bor (hafta dushanbadan boshlanadi),
2009-yil 31-dekabr va 2012-yil 31-dekabr orasida:

<% fromDate=CDate("2009/12/31") toDate=CDate("2012/12/31") response.write(DateDiff("w",fromDate,toDate,vbMonday)) %>

Yuqoridagi kodning natijasi quyidagicha bo‘ladi:

156
Misolni ko‘rsatish »


❮ To‘liq VBScript ma’lumotnomasi

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!