Maitiro ekuwedzera uye kubvisa mazuva uye nguva muMySQL

Refer

DATE_ADD uye DATE_SUB

Aya mabasa maviri mapara, imwe kuwedzera uye imwe kubvisa. Basa ravo nderekuwedzera kana kubvisa nguva kubva pazuva rakatarwa. Zvekushandisa chaiko, tarisa kune inotevera muenzaniso. Mumuenzaniso wekutanga, tinowedzera mwedzi mumwe kunguva yazvino, uye yechipiri inobvisa mwedzi mumwe kubva panguva iripo.

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

Wedzera uye SUBDATE

Aya mabasa maviri zvakare mapara, imwe kuwedzera uye imwe kubvisa. Mashandisiro avo akafanana neDATE_ADD uye DATE_SUB. Zvekushandisa chaiko, tarisa kune inotevera muenzaniso. Mumuenzaniso wekutanga, tinowedzera mwedzi mumwe kunguva yazvino, uye yechipiri inobvisa mwedzi mumwe kubva panguva iripo.

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

Zvimwe kushandiswa

Isu tinongoshandisa mwedzi separameter mumuenzaniso, zvisinei, awa, miniti, wechipiri, svondo, zuva, gore rinogona kushandiswa semiparamendi, uye zvakare rinogona kutsigira maminetsi nemasekondi, maawa nemaminetsi nemasekondi uye nezvimwe mubatanidzwa. Kuti uwane rumwe ruzivo, ndapota tarisa kune iri pasi pazasi

            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'
        

mamwe mashoko

Muchokwadi, kubvisa kunogona zvakare kushandisa DATE_ADD, isu tinongoda kunyora paramende senhamba isina kunaka. Uye zvakare, MariaDB ibazi reMySQL, uye yavo SQL syntax yakangofanana, saka kune mamwe mabasa ari pamusoro paMariaDB, uye mashandisiro acho akafanana.