DATE_SUB

Sanadan 10 kunni olib tashlang va sanani qaytaring:

SELECT DATE_SUB("2017-06-15", INTERVAL 10 DAY);

Ta’rif va qo‘llanilishi

DATE_SUB() funksiyasi sanadan vaqt/sana oralig‘ini ayiradi va hosil bo‘lgan sanani qaytaradi.

DATE_SUB(date, INTERVAL value interval)

Parametr	Tavsif
date	Majburiy. O‘zgartirish sanasi
value	Majburiy. Ayirish uchun vaqt/sana oralig‘ining qiymati. Ham ijobiy, ham salbiy qiymatlarga ruxsat beriladi
interval	Required. The type of interval to subtract. Can be one of the following values: 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

Qo‘llab-quvvatlaydigan tizimlar:	MySQL 4.0 versiyasidan boshlab

Sanadan 15 daqiqani ayirib, sanani qaytaring:

SELECT DATE_SUB("2017-06-15 09:34:21", INTERVAL 15 MINUTE);

Sanadan 3 soatni ayirib, sanani qaytaring:

SELECT DATE_SUB("2017-06-15 09:34:21", INTERVAL 3 HOUR);

Sanaga 2 oy qo‘shing va sanani qaytaring:

SELECT DATE_SUB("2017-06-15", INTERVAL -2 MONTH);

Yutuqlaringizni kuzating – bu bepul!