-- Run only in a fresh bhylu_mysql_lab seeded from repair-seed.sql.
SET NAMES utf8mb4 COLLATE utf8mb4_0900_ai_ci;
SET SESSION sql_mode = 'STRICT_TRANS_TABLES,ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
SET SESSION time_zone = '+00:00';
SET SESSION lc_time_names = 'en_US';
SELECT 'DATE_ADD' AS operation, DATE_ADD('2026-02-14',INTERVAL 2 DAY) AS result;
SELECT 'ADDDATE' AS operation, ADDDATE('2026-02-14',2) AS result;
SELECT 'DATE_SUB' AS operation, DATE_SUB('2026-02-14',INTERVAL 2 DAY) AS result;
SELECT 'SUBDATE' AS operation, SUBDATE('2026-02-14',2) AS result;
SELECT 'DATEDIFF' AS operation, DATEDIFF('2026-02-14 10:00:00','2026-02-12 23:00:00') AS result;