EXTRACT

Sanadan oyni ajratib olish:

SELECT EXTRACT(MONTH FROM "2017-06-15");

Ta’rif va qo‘llanilishi

EXTRACT() funksiyasi berilgan sanadan bir qismni ajratib oladi.

EXTRACT(part FROM date)

Parametr	Tavsif
part	Required. The part to extract. Can be one of the following: MICROSECOND SECOND MINUTE HOUR DAY WEEK MONTH QUARTER YEAR SECOND_MICROSECOND MINUTE_MICROSECOND MINUTE_SECOND HOUR_MICROSECOND HOUR_SECOND HOUR_MINUTE DAY_MICROSECOND DAY_SECOND DAY_MINUTE DAY_HOUR YEAR_MONTH
date	Majburiy. Bir qismini ajratib olish sanasi

Qo‘llab-quvvatlaydigan tizimlar:	MySQL 4.0 versiyasidan boshlab

Sanadan haftani ajratib olish:

SELECT EXTRACT(WEEK FROM "2017-06-15");

Sana-vaqtdan daqiqani ajratib olish:

SELECT EXTRACT(MINUTE FROM "2017-06-15 09:34:21");

Sana vaqtidan yil va oyni chiqarib oling:

SELECT EXTRACT(YEAR_MONTH FROM "2017-06-15 09:34:21");

Yutuqlaringizni kuzating – bu bepul!