Nigute ushobora kongeramo no gukuramo amatariki nibihe muri MySQL

Reba

DATE_ADD na DATE_SUB

Iyi mikorere yombi ni couple, imwe yongeyeho indi ni gukuramo. Igikorwa cabo nukwongera cyangwa gukuramo igihe runaka uhereye kumunsi wagenwe. Kubikoresha byihariye, reba kurugero rukurikira. Murugero rwambere, twongeyeho ukwezi kumwanya wigihe, naho icya kabiri gikuramo ukwezi kumwe uhereye kurubu.

            SELECT DATE_ADD(now(), INTERVAL 1 MONTH);
SELECT DATE_SUB(now(), INTERVAL 1 MONTH);
        

WONGEYE KANDI SUBDATE

Iyi mikorere yombi nayo ni couple, imwe yongeyeho indi ni gukuramo. Imikoreshereze yabo ni kimwe na DATE_ADD na DATE_SUB. Kubikoresha byihariye, reba kurugero rukurikira. Murugero rwambere, twongeyeho ukwezi kumwanya wigihe, naho icya kabiri gikuramo ukwezi kumwe uhereye kurubu.

            SELECT ADDDATE(now(), INTERVAL 1 MONTH);
SELECT SUBDATE(now(), INTERVAL 1 MONTH);
        

Ikoreshwa ryinshi

Dukoresha ukwezi gusa nkibipimo murugero, icyakora, isaha, umunota, kabiri, icyumweru, umunsi, umwaka nabyo birashobora gukoreshwa nkibipimo, kandi birashobora no gushyigikira iminota namasegonda, amasaha niminota n'amasegonda nibindi byinshi guhuza. Kubisobanuro birambuye, nyamuneka reba kurutonde rukurikira.

            MICROSECOND
SECOND
MINUTE
HOUR
DAY
WEEK
MONTH
QUARTER
YEAR
SECOND_MICROSECOND 'SECONDS.MICROSECONDS'
MINUTE_MICROSECOND 'MINUTES:SECONDS.MICROSECONDS'
MINUTE_SECOND 'MINUTES:SECONDS'
HOUR_MICROSECOND 'HOURS:MINUTES:SECONDS.MICROSECONDS'
HOUR_SECOND 'HOURS:MINUTES:SECONDS'
HOUR_MINUTE 'HOURS:MINUTES'
DAY_MICROSECOND 'DAYS HOURS:MINUTES:SECONDS.MICROSECONDS'
DAY_SECOND 'DAYS HOURS:MINUTES:SECONDS'
DAY_MINUTE 'DAYS HOURS:MINUTES'
DAY_HOUR 'DAYS HOURS'
YEAR_MONTH 'YEARS-MONTHS'
        

andi makuru

Mubyukuri, gukuramo birashobora kandi gukoresha DATE_ADD, dukeneye gusa kwandika ibipimo nkumubare mubi. Mubyongeyeho, MariaDB nishami rya MySQL, kandi syntax yabo ya SQL irasa cyane, nuko hariho imirimo ine yavuzwe haruguru kuri MariaDB, kandi imikoreshereze irasa neza.