INTERVAL()

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

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES