Ungangeza kanjani futhi ususe izinsuku nezikhathi ku-MySQL

Inkomba

DATE_ADD no-DATE_SUB

Le misebenzi emibili iyibhangqa, owodwa uyengeza kanti omunye ukukhipha. Umsebenzi wabo ukufaka noma ukususa isikhathi kusuka osukwini olubekiwe. Ngokusetshenziswa okuthile, bheka isibonelo esilandelayo. Esibonelweni sokuqala, sengeza inyanga eyodwa esikhathini samanje, bese kuthi eyesibili isuse inyanga eyodwa kusukela esikhathini samanje.

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

Yengeza futhi BHALISA

Le misebenzi emibili nayo iyibhangqa, owodwa uyengeza kanti omunye ukukhipha. Ukusetshenziswa kwabo kuyefana no-DATE_ADD no-DATE_SUB. Ngokusetshenziswa okuthile, bheka isibonelo esilandelayo. Esibonelweni sokuqala, sengeza inyanga eyodwa esikhathini samanje, bese kuthi eyesibili isuse inyanga eyodwa kusukela esikhathini samanje.

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

Ukusetshenziswa okuningi

Sisebenzisa kuphela inyanga njengepharamitha esibonelweni, kepha, ihora, iminithi, isibili, isonto, usuku, unyaka lungasetshenziswa njengamapharamitha, futhi lingaxhasa futhi imizuzu namasekhondi, amahora nemizuzu namasekhondi nokuningi inhlanganisela. Ngemininingwane, sicela ubheke uhlu olungezansi.

            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

Eqinisweni, ukukhipha kungasebenzisa futhi i-DATE_ADD, sidinga ukubhala ipharamitha kuphela njengenombolo engeyona. Ngaphezu kwalokho, iMariaDB igatsha le-MySQL, futhi i-syntax yabo ye-SQL ngokufanayo iyafana, ngakho-ke kunemisebenzi emine engenhla kuMariaDB, futhi ukusetshenziswa kufana ncamashi.