Me pehea te taapiri me te tango i nga ra me nga waa i roto i te MySQL

Tohutoro

DATE_ADD me DATE_SUB

Ko enei mahi e rua he takirua, ko te kotahi he taapiri ko tetahi hei tango. Ko ta raatau mahi he taapiri, he tango ranei i tetahi waa mai i te ra i whakaritea. Mo nga whakamahinga motuhake, tirohia te tauira e whai ake nei. I te tauira tuatahi, ka taapirihia e maatau kotahi marama ki te waa onaianei, a ko te tuarua ka tango i te marama kotahi mai i tenei wa.

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

WHAKANUI me TE WHAKAPONO

Ko enei mahi e rua he takirua ano tetahi, he taapiri tetahi me te tango tetahi. Ko ta raatau whakamahinga he rite ki DATE_ADD me DATE_SUB. Mo nga whakamahinga motuhake, tirohia te tauira e whai ake nei. I te tauira tuatahi, ka taapirihia e maatau kotahi marama ki te waa onaianei, a ko te tuarua ka tango i te marama kotahi mai i tenei wa.

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

Te whakamahinga ake

Ka whakamahia noa e maatau te marama hei waahanga i roto i te tauira, heoi, ko te haora, te meneti, te tuarua, te wiki, te ra, te tau ka taea te whakamahi hei taapara, ka taea hoki te tautoko i nga meneti me nga hēkona, haora me nga meneti me nga hēkona huinga. Mo nga korero taipitopito, tirohia te raarangi o raro.

            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'
        

etahi atu korero

Inaa hoki, ka taea hoki e te tangohanga te whakamahi i te DATE_ADD, me tuhi noa e matou te tohu hei tau kino. Hei taapiri, ko te MariaDB he peka o MySQL, a he rite tonu ta ratou wetereo SQL, no reira kei runga ake e wha nga mahi kei runga i a MariaDB, a he orite tonu te whakamahinga.