Uyongeza njani kwaye uthabathe imihla kunye namaxesha kwi-MySQL

Isalathiso

DATE_ADD kunye ne-DATE_SUB

Le misebenzi mibini zizibini, enye idibanisa kwaye enye kukuthabatha. Umsebenzi wabo ukongeza okanye ukuthabatha ixesha ukusuka kumhla ochaziweyo. Ukusetyenziswa okuthile, bhekisa kulo mzekelo ulandelayo. Kumzekelo wokuqala, songeza inyanga enye kwixesha langoku, kwaye eyesibini ikhupha inyanga enye ukusuka kwixesha langoku.

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

Yongeza kunye neNkcazo

Le misebenzi mibini ikwangababini, omnye uyongezwa kwaye omnye kukuthabatha. Ukusetyenziswa kwabo kuyafana ne-DATE_ADD kunye ne-DATE_SUB. Ukusetyenziswa okuthile, bhekisa kulo mzekelo ulandelayo. Kumzekelo wokuqala, songeza inyanga enye kwixesha langoku, kwaye eyesibini ikhupha inyanga enye ukusuka kwixesha langoku.

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

Ukusetyenziswa okungakumbi

Sisebenzisa kuphela inyanga njengeparameter kumzekelo, nangona kunjalo, iyure, umzuzu, owesibini, iveki, usuku, unyaka unokusetyenziswa njengeeparameter, kwaye unokuxhasa imizuzu nemizuzwana, iiyure kunye nemizuzu kunye nemizuzwana nokunye indibaniselwano. Ngeenkcukacha, nceda ujonge kuluhlu olungezantsi.

            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'
        

Olunye ulwazi

Ngapha koko, ukuthabatha kunokusebenzisa i-DATE_ADD, kufuneka sibhale kuphela ipharamitha njengenani elingelilo. Ukongeza, uMariaDB lisebe le-MySQL, kwaye i-syntax yabo ye-SQL ngokufanayo iyafana, ke kukho le misebenzi mine ingentla kuMariaDB, kunye nokusetyenziswa kuyafana.