Momwe mungawonjezere ndikuchotsera masiku ndi nthawi mu MySQL

Kutchulidwa

DATE_ADD ndi DATE_SUB

Ntchito ziwirizi ndi ziwiri, imodzi ndikuwonjezera ndipo inayo ndikuchotsa. Ntchito yawo ndikuwonjezera kapena kuchotsa kanthawi kuchokera tsiku lomwe latchulidwalo. Kuti mugwiritse ntchito, onani chitsanzo chotsatirachi. Mu chitsanzo choyamba, timawonjezera mwezi umodzi pakadali pano, ndipo wachiwiri umachotsa mwezi umodzi kuchokera pano.

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

Onjezani ndi SUBDATE

Ntchito ziwirizi ndi ziwiri, imodzi ndikuwonjezera ndipo inayo ndikuchotsa. Kugwiritsa ntchito kwawo ndikofanana ndi DATE_ADD ndi DATE_SUB. Kuti mugwiritse ntchito, onani chitsanzo chotsatirachi. Mu chitsanzo choyamba, timawonjezera mwezi umodzi pakadali pano, ndipo wachiwiri umachotsa mwezi umodzi kuchokera pano.

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

Kugwiritsa ntchito kwambiri

Timangogwiritsa ntchito mwezi ngati gawo lachitsanzo, komabe, ola, mphindi, yachiwiri, sabata, tsiku, chaka chitha kugwiritsidwanso ntchito ngati magawo, komanso titha kuthandizira mphindi ndi masekondi, maola ndi mphindi ndi masekondi ndi zina zambiri kuphatikiza. Kuti mumve zambiri, chonde onani mndandanda womwe uli pansipa.

            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'
        

zina

M'malo mwake, kuchotsa kumatha kugwiritsanso ntchito DATE_ADD, tifunikira kungolemba gawo ngati nambala yolakwika. Kuphatikiza apo, MariaDB ndi nthambi ya MySQL, ndipo syntax yawo ya SQL ndiyofanana, chifukwa chake pali ntchito zinayi pamwambapa pa MariaDB, ndikugwiritsanso ntchito chimodzimodzi.