Sertifikat olingYANGIW3Schools ilovasiiOS va AndroidSarguzashtni boshlang

DATENAME

Misol

Sananing ko‘rsatilgan qismini qaytaring:

SELECT DATENAME(year, '2017/08/25') AS DatePartString;
O‘zingiz sinab ko‘ring »
baham ko'ring

Ta’rif va qo‘llanilishi

DATENAME() funksiyasi sananing ko‘rsatilgan qismini qaytaradi.

Bu funksiya natijani string qiymati sifatida qaytaradi.

Sintaksis

DATENAME(interval, date)

Parametr qiymatlari

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
date Majburiy. Foydalanish sanasi

Texnik tafsilotlar

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

Ko‘proq misollar

Misol

Sananing ko‘rsatilgan qismini qaytaring:

SELECT DATENAME(yy, '2017/08/25') AS DatePartString;
O‘zingiz sinab ko‘ring »

Misol

Sananing ko‘rsatilgan qismini qaytaring:

SELECT DATENAME(month, '2017/08/25') AS DatePartString;
O‘zingiz sinab ko‘ring »

Misol

Sananing ko‘rsatilgan qismini qaytaring:

SELECT DATENAME(hour, '2017/08/25 08:36') AS DatePartString;
O‘zingiz sinab ko‘ring »

Misol

Sananing ko‘rsatilgan qismini qaytaring:

SELECT DATENAME(minute, '2017/08/25 08:36') AS DatePartString;
O‘zingiz sinab ko‘ring »

‹ OrqagaKeyingisi

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!

Ro'yxatdan o'tishKirish