Yadda ake karawa da rage kwanan wata da lokuta a cikin MySQL

Magana

DATE_ADD da DATE_SUB

Wadannan ayyuka guda biyu ne, daya kari ne dayan kuma ragi ne. Aikin su shine kara ko rage wani lokaci daga ranar da aka kayyade. Don takamaiman amfani, koma zuwa misali mai zuwa. A misali na farko, zamu kara wata daya zuwa yanzu, na biyu kuma ya rage wata daya daga yanzu.

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

ADDDATE da SUBDATE

Wadannan ayyuka guda biyu suma suna hade ne, daya kari ne dayan kuma ragi ne. Amfani da su daidai yake da DATE_ADD da DATE_SUB. Don takamaiman amfani, koma zuwa misali mai zuwa. A misali na farko, zamu kara wata daya zuwa yanzu, na biyu kuma ya rage wata daya daga yanzu.

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

Usagearin amfani

Muna amfani da wata ne kawai azaman ma'auni a cikin misalin, duk da haka, awa, minti, na biyu, mako, rana, shekara kuma ana iya amfani da shi azaman sigogi, kuma yana iya tallafawa minti da sakan, awanni da mintuna da sakan da ƙari hadewa. Don cikakkun bayanai, da fatan za a koma zuwa jerin da ke ƙasa.

            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'
        

wasu bayanai

A zahiri, ragi zai iya amfani da DATE_ADD, kawai muna buƙatar rubuta ma'aunin azaman lambar mara kyau. Bugu da kari, MariaDB reshe ne na MySQL, kuma tsarin rubutun su na SQL daidai yake, saboda haka akwai ayyuka guda hudu da ke sama akan MariaDB, kuma yadda ake amfani dasu daidai yake.