Otu esi tinye ma wepu oge na oge na MySQL

Ntughari

DATE_ADD na DATE_SUB

Ọrụ abụọ a bụ ụzọ, otu bụ mgbakwunye na nke ọzọ bụ mwepu. Ọrụ ha bụ ịgbakwunye ma ọ bụ wepu oge site na ụbọchị akọwapụtara. Maka iji ya mee ihe, zoo aka na ihe atụ a. Na ihe atụ nke mbụ, anyị na-agbakwunye otu ọnwa na nke ugbu a, na nke abụọ na-ewepu otu ọnwa site na oge ugbu a.

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

Tinye na SUBDATE

Ọrụ abụọ a bụkwa ụzọ abụọ, otu bụ mgbakwunye na nke ọzọ bụ mwepu. Ojiji ha dikwa ka DATE_ADD na DATE_SUB. Maka iji ya mee ihe, zoo aka na ihe atụ a. Na ihe atụ nke mbụ, anyị na-agbakwunye otu ọnwa na nke ugbu a, na nke abụọ na-ewepu otu ọnwa site na oge ugbu a.

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

Ojiji ndị ọzọ

Naanị anyị na-eji ọnwa dịka oke na ihe atụ, agbanyeghị, oge, nkeji, nke abụọ, izu, ụbọchị, afọ, enwere ike iji ya dị ka oke, ọ nwekwara ike ịkwado nkeji na sekọnd, awa na nkeji na sekọnd na ndị ọzọ Nchikota. Maka nkọwapụta, biko rụtụ aka na ndepụta dị n'okpuru.

            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'
        

ozi ndị ọzọ

N'ezie, mwepu nwekwara ike iji DATE_ADD, naanị anyị ga-ede oke dị ka ọnụọgụ adịghị mma. Na mgbakwunye, MariaDB bụ ngalaba nke MySQL, na syntax ha SQL bụ otu, yabụ enwere ọrụ anọ dị n'elu na MariaDB, ojiji a bụkwa otu.