INTERVAL()
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Returns the index of the last argument that is less than the first argument or is NULL.
EXAMPLES
SELECT INTERVAL(10, 1, 2, 3, 4, 5, 15);
+---------------------------------+
| INTERVAL(10, 1, 2, 3, 4, 5, 15) |
+---------------------------------+
| 5 |
+---------------------------------+
SELECT INTERVAL(NULL, 1, 2, 3, 4, 5, 15);
+-----------------------------------+
| INTERVAL(NULL, 1, 2, 3, 4, 5, 15) |
+-----------------------------------+
| -1 |
+-----------------------------------+
SELECT INTERVAL(10, 2, 3, 4, 5);
+--------------------------+
| INTERVAL(10, 2, 3, 4, 5) |
+--------------------------+
| 4 |
+--------------------------+
SELECT INTERVAL(1, 2, 3, 4, 5);
+-------------------------+
| INTERVAL(1, 2, 3, 4, 5) |
+-------------------------+
| 0 |
+-------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.