MySQL Tutorial/Comparison Functions Operators/INTERVAL

INTERVAL(N,N1,N2,N3,...): Returns 0 if N

mysql>
mysql> SELECT INTERVAL(2, 1, 5, 7, 3, 4, 2);
+-------------------------------+
| INTERVAL(2, 1, 5, 7, 3, 4, 2) |
+-------------------------------+
|                             1 |
+-------------------------------+
1 row in set (0.03 sec)
mysql> SELECT INTERVAL(10, 12, 11, 1, 10);
+-----------------------------+
| INTERVAL(10, 12, 11, 1, 10) |
+-----------------------------+
|                           0 |
+-----------------------------+
1 row in set (0.00 sec)
mysql> SELECT INTERVAL(2, 3, 0, 4, 2);
+-------------------------+
| INTERVAL(2, 3, 0, 4, 2) |
+-------------------------+
|                       0 |
+-------------------------+
1 row in set (0.01 sec)
mysql>
mysql>
mysql>