MySQL INTERVAL कीवर्ड के साथ उपयोग की जा सकने वाली विभिन्न यूनिट वैल्यू निम्नलिखित हैं:
MICROSECOND
निर्दिष्ट माइक्रोसेकंड की संख्या को वर्तमान समय या उपयोगकर्ता द्वारा प्रदान किए गए समय में जोड़ने/घटाने के लिए।
mysql> SELECT NOW() + INTERVAL 100 MICROSECOND;
+--------------------------------+
| NOW() + INTERVAL 100 MICROSECOND |
+--------------------------------+
| 2017-10-28 18:47:25.000100 |
+--------------------------------+SECOND
mysql> SELECT NOW() + INTERVAL 59 SECOND;
+--------------------------+
| NOW() + INTERVAL 59 SECOND |
+--------------------------+
| 2017-10-28 18:49:30 |
+--------------------------+MINUTE
mysql> SELECT NOW() + INTERVAL 10 MINUTE;
+--------------------------+
| NOW() + INTERVAL 10 MINUTE |
+--------------------------+
| 2017-10-28 18:58:44 |
+--------------------------+HOUR
mysql> SELECT NOW() + INTERVAL 2 HOUR;
+-----------------------+
| NOW() + INTERVAL 2 HOUR |
+-----------------------+
| 2017-10-28 20:55:44 |
+-----------------------+DAY
mysql> SELECT NOW() + INTERVAL 10 DAY;
+-----------------------+
| NOW() + INTERVAL 10 DAY |
+-----------------------+
| 2017-11-07 18:48:53 |
+-----------------------+WEEK
mysql> SELECT NOW() + INTERVAL 1 WEEK;
+-----------------------+
| NOW() + INTERVAL 1 WEEK |
+-----------------------+
| 2017-11-04 18:49:10 |
+-----------------------+MONTH
mysql> SELECT NOW() + INTERVAL 1 MONTH;
+------------------------+
| NOW() + INTERVAL 1 MONTH |
+------------------------+
| 2017-11-28 18:49:31 |
+------------------------+QUARTER
mysql> SELECT NOW() + INTERVAL 1 QUARTER;
+--------------------------+
| NOW() + INTERVAL 1 QUARTER |
+--------------------------+
| 2018-01-28 18:49:41 |
+--------------------------+YEAR
mysql> SELECT NOW() + INTERVAL 1 YEAR;
+-----------------------+
| NOW() + INTERVAL 1 YEAR |
+-----------------------+
| 2018-10-28 18:49:48 |
+-----------------------+सभी यूनिट कीवर्ड एकवचन रूप में होने चाहिए (जैसे DAY, नहीं DAYS)।
