Sertifikat olingYANGIW3Schools ilovasiiOS va AndroidSarguzashtni boshlang

Format

Misol

"BirthDate" ustunini uzun sana formatiga keltirish:

SELECT Format(BirthDate, "Long Date") AS FormattedBirthDate
FROM Employees;
O‘zingiz sinab ko‘ring »
baham ko'ring

Ta’rif va qo‘llanilishi

Format() funksiyasi sana qiymatini ko‘rsatilgan formatda formatlaydi.

Sintaksis

Format(value, format, firstdayofweek, firstweekofyear)

Parametr qiymatlari

Parametr Tavsif
value Majburiy. Formatlash uchun sana qiymati
format Optional. The format to use.
Format Tavsif
General Date Tizim sozlamalari asosida qiymatni sana sifatida ko‘rsatadi
Long Date Tizimning uzoq sana sozlamalari asosida qiymatni sana sifatida ko‘rsatadi
Medium Date Tizimning o‘rta sana sozlamalari asosida qiymatni sana sifatida ko‘rsatadi
Short Date Tizimning qisqa sana sozlamalari asosida qiymatni sana sifatida ko‘rsatadi
Long Time Tizimning uzoq vaqt sozlamalari asosida qiymatni sana sifatida ko‘rsatadi
Medium Time Tizimning o‘rtacha vaqt sozlamalariga asoslangan sana sifatida qiymatni ko‘rsatadi
Short Time Tizimning qisqa vaqt sozlamalari asosida qiymatni sana sifatida ko‘rsatadi
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

Texnik tafsilotlar

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

‹ OrqagaKeyingisi

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!

Ro'yxatdan o'tishKirish