Yuav ua li cas ntxiv thiab rho tawm hnub thiab lub sijhawm hauv MySQL

Kev siv

DATE_ADD thiab DATE_SUB

Ob txoj haujlwm no yog ua khub, ib qho yog ntxiv thiab lwm qhov yog rho tawm. Lawv txoj haujlwm yog ntxiv lossis rho ib lub sijhawm ntawm hnub uas tau hais tseg. Rau kev siv tshwj xeeb, saib rau cov qauv hauv qab no. Hauv thawj qhov piv txwv, peb ntxiv ib hlis ntxiv rau lub sijhawm tam sim no, thiab tus thib ob rho tawm ib hlis ntawm lub sijhawm tam sim no.

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

NTXIV THIAB SUBDATE

Ob txoj haujlwm no tseem yog ua khub, ib qho yog ntxiv thiab lwm qhov yog rho tawm. Lawv cov kev siv yog tib yam li DATE_ADD thiab DATE_SUB. Rau kev siv tshwj xeeb, saib rau cov qauv hauv qab no. Hauv thawj qhov piv txwv, peb ntxiv ib hlis ntxiv rau lub sijhawm tam sim no, thiab tus thib ob rho tawm ib hlis ntawm lub sijhawm tam sim no.

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

Siv ntau dua

Peb tsuas yog siv lub hli ua qhov ntsuas nyob hauv qhov piv txwv, txawm li cas los xij, teev, feeb, thib ob, lub lim tiam, hnub, xyoo tseem tuaj yeem siv ua cov tsis suav, thiab tseem tuaj yeem txhawb cov feeb thiab feeb, teev thiab feeb thiab feeb thiab ntau dua kev sib xyaw ua ke. Yog xav paub cov ntsiab lus, thov saib cov npe hauv qab no.

            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'
        

lwm cov ntaub ntawv

Qhov tseeb, kev rho tawm tseem siv tau DATE_ADD, peb tsuas yog yuav tsum sau tus parameter yog tus lej tsis zoo. Ib qho ntxiv, MariaDB yog ceg ntawm MySQL, thiab lawv cov syntax SQL yeej qhov zoo ib yam, yog li muaj plaub lub zog ntawm MariaDB, thiab kev siv yog zoo ib yam nkaus.