Mokhoa oa ho eketsa le ho tlosa matsatsi le linako ho MySQL

Tšupiso

DATE_ADD le DATE_SUB

Mesebetsi ena e 'meli ke para, e' ngoe ke tlatsetso 'me e' ngoe ke ho tlosa. Mosebetsi oa bona ke ho eketsa kapa ho tlosa nako ho tloha letsatsing le boletsoeng. Bakeng sa ts'ebeliso e ikhethang, sheba mohlala o latelang. Mohlala oa pele, re eketsa khoeli e le 'ngoe ho nako ea hajoale,' me ea bobeli e tlosa khoeli e le 'ngoe ho tloha nakong ea hajoale.

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

EKETSA le TLATSO

Mesebetsi ena e 'meli hape ke para, e' ngoe ke tlatsetso ha e 'ngoe ke ho tlosa. Tšebeliso ea bona e ts'oana le DATE_ADD le DATE_SUB. Bakeng sa ts'ebeliso e ikhethang, sheba mohlala o latelang. Mohlala oa pele, re eketsa khoeli e le 'ngoe ho nako ea hajoale,' me ea bobeli e tlosa khoeli e le 'ngoe ho tloha nakong ea hajoale.

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

Ts'ebeliso e ngoe hape

Re sebelisa khoeli feela e le parameter mohlaleng, leha ho le joalo, hora, motsotso, ea bobeli, beke, letsatsi, selemo le tsona li ka sebelisoa e le mekhahlelo, hape li ka ts'ehetsa metsotso le metsotsoana, lihora le metsotso le metsotsoana le tse ling. motswako. Bakeng sa lintlha, ka kopo sheba lenane le ka tlase.

            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'
        

boitsebiso bo bong

Ebile, ho tlosa ho ka sebelisa DATE_ADD, re hloka feela ho ngola parameter e le nomoro e fosahetseng. Ntle le moo, MariaDB ke lekala la MySQL, mme syntax ea bona ea SQL ha e ts'oane, ka hona ho na le mesebetsi e mene e boletsoeng kaholimo ho MariaDB, mme ts'ebeliso e ts'oana hantle.