OceanBase AI Database supports date and time operators, which have the same functionality as the corresponding built-in date and time functions.
The following table describes the date and time operators supported by the current version of OceanBase AI Database.
For example:
obclient> SELECT '2008-12-31 23:59:59' + INTERVAL 1 SECOND;
+-------------------------------------------+
| '2008-12-31 23:59:59' + INTERVAL 1 SECOND |
+-------------------------------------------+
| 2009-01-01 00:00:00 |
+-------------------------------------------+
1 row in set