DATE_ADD

Sanaga 10 kun qo‘shing va sanani qaytaring:

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

Ta’rif va qo‘llanilishi

DATE_ADD() funksiyasi sanaga vaqt/sana oralig‘ini qo‘shadi va hosil bo‘lgan sanani qaytaradi.

DATE_ADD(date, INTERVAL value addunit)

Parametr	Tavsif
date	Majburiy. O‘zgartirish sanasi
value	Majburiy. Qo‘shiladigan vaqt/sana oralig‘ining qiymati. Ham ijobiy, ham salbiy qiymatlarga ruxsat beriladi
addunit	Required. The type of interval to add. 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

Sanaga 15 daqiqa qo‘shing va sanani qaytaring:

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

Sanadan 3 soatni ayirib, sanani qaytaring:

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

2 oyni sanaga ayirib, sanani qaytaring:

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

Yutuqlaringizni kuzating – bu bepul!