MYSQL
-- 获取当前日期
SELECT CURDATE() AS to_day;
-- 获取后一天
SELECT DATE_ADD(CURDATE(), INTERVAL 1 DAY) AS next_day;
SQL SERVER
-- 获取当前日期
SELECT GETDATE() AS to_day;
-- 获取后一天
SELECT DATEADD(DAY, 1, GETDATE()) AS next_day;
MYSQL
-- 获取当前日期
SELECT CURDATE() AS to_day;
-- 获取后一天
SELECT DATE_ADD(CURDATE(), INTERVAL 1 DAY) AS next_day;
SQL SERVER
-- 获取当前日期
SELECT GETDATE() AS to_day;
-- 获取后一天
SELECT DATEADD(DAY, 1, GETDATE()) AS next_day;
1万+
1363
2285
1486
8192

被折叠的 条评论
为什么被折叠?