Faʻafefea ona faʻaopopo ma toʻesea aso ma taimi i MySQL

Tusitusiga

DATE_ADD ma DATE_SUB

O nei galuega e lua o se paga, o le tasi o le faʻaopoopo ae o le isi o le toʻeseʻese. O la latou galuega o le faʻaopopo pe toʻese se vaitaimi mai le aso atofaina. Mo faʻapitoa faʻaaoga, vaʻai i le faʻataʻitaʻiga lenei. I le muamua faʻataʻitaʻiga, matou te faʻaopopoina le tasi masina i le taimi nei, ma le lona lua tasi toʻesea le tasi masina mai le taimi nei.

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

FAʻAOPOOPO ma TUA

O nei galuega e lua o se paga foʻi, o le tasi o le faʻaopoopo ae o le isi o le toʻeseʻese. O latou faʻaaogaina e tutusa ma DATE_ADD ma DATE_SUB. Mo faʻapitoa faʻaaoga, vaʻai i le faʻataʻitaʻiga lenei. I le muamua faʻataʻitaʻiga, matou te faʻaopopoina le tasi masina i le taimi nei, ma le lona lua tasi toʻesea le tasi masina mai le taimi nei.

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

Tele faʻaaogaina

E naʻo le masina e fai ma faʻataʻitaʻiga i le faʻataʻitaʻiga, ae ui i lea, itula, minute, lona lua, vaiaso, aso, tausaga e mafai foi ona faʻaaoga e fai ma tapulaʻa, ma mafai foi ona lagolagoina minute ma sekone, itula ma minute ma sekone ma sili tuʻufaʻatasiga Mo auiliiliga, faʻamolemole tagaʻi i le lisi i lalo.

            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'
        

isi faʻamatalaga

O le mea moni, toʻese mafai mafai foi ona faʻaaoga DATE_ADD, e naʻo lo tatou manaʻomia e tusi le tapulaʻa o se le lelei numera. I se faʻaopopoga, o MariaDB o se lala o MySQL, ma o la latou SQL faʻamatalaga e tutusa lava, o lea e i ai galuega e fa i luga atu o MariaDB, ma o le faʻaaogaina e tutusa lelei.