MySQL में DATETIME में 30 मिनट कैसे जोड़ें?

MySQL में DATE_ADD() फंक्शन का उपयोग करके DATETIME कॉलम में मिनट जोड़ें।

सिंटैक्स

SELECT DATE_ADD(yourDateTimeColumn, INTERVAL 30 MINUTE) FROM yourTableName;

उदाहरण

टेबल बनाना

mysql> create table Add30MinutesDemo (
-> YourTime datetime
-> ); Query OK, 0 rows affected (0.67 sec)

वर्तमान समय डालना

mysql> insert into Add30MinutesDemo values(now());

वर्तमान मान देखना

mysql> select *from Add30MinutesDemo;

+---------------------+
| YourTime            |
+---------------------+
| 2018-12-07 18:03:51 |
+---------------------+

30 मिनट जोड़ना

mysql> select date_add(YourTime, interval 30 minute) from Add30MinutesDemo;

+---------------------------------------+
| date_add(YourTime, interval 30 minute) |
+---------------------------------------+
| 2018-12-07 18:33:51                   |
+---------------------------------------+

DATE_ADD के अन्य समय इकाइयाँ

इकाई	उदाहरण
MICROSECOND	INTERVAL 500 MICROSECOND
SECOND	INTERVAL 30 SECOND
MINUTE	INTERVAL 30 MINUTE
HOUR	INTERVAL 2 HOUR
DAY	INTERVAL 1 DAY
WEEK	INTERVAL 1 WEEK
MONTH	INTERVAL 1 MONTH
QUARTER	INTERVAL 1 QUARTER
YEAR	INTERVAL 1 YEAR
SECOND_MICROSECOND	INTERVAL '1.5' SECOND_MICROSECOND
MINUTE_MICROSECOND	INTERVAL '1:30.5' MINUTE_MICROSECOND
MINUTE_SECOND	INTERVAL '1:30' MINUTE_SECOND
HOUR_MICROSECOND	INTERVAL '1:30:0.5' HOUR_MICROSECOND
HOUR_SECOND	INTERVAL '1:30:00' HOUR_SECOND
HOUR_MINUTE	INTERVAL '1:30' HOUR_MINUTE
DAY_MICROSECOND	INTERVAL '1 12:30:0.5' DAY_MICROSECOND
DAY_SECOND	INTERVAL '1 12:30:00' DAY_SECOND
DAY_MINUTE	INTERVAL '1 12:30' DAY_MINUTE
DAY_HOUR	INTERVAL '1 12' DAY_HOUR
YEAR_MONTH	INTERVAL '1-6' YEAR_MONTH

घटाने के लिए DATE_SUB

SELECT DATE_SUB(NOW(), INTERVAL 30 MINUTE) AS thirty_min_ago;

अंकगणित ऑपरेटर (MySQL 8.0+)

SELECT NOW() + INTERVAL 30 MINUTE;
SELECT YourTime + INTERVAL 30 MINUTE FROM Add30MinutesDemo;

UPDATE में उपयोग

UPDATE appointments 
SET appointment_time = DATE_ADD(appointment_time, INTERVAL 30 MINUTE)
WHERE id = 123;