We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
-- 当前日期 SELECT CURDATE(); -- 当前日期+时间 SELECT NOW(); -- 明天 SELECT ADDDATE(CURDATE(), 1); -- 昨天 SELECT SUBDATE(CURDATE(), 1); -- 上周 SELECT SUBDATE(CURDATE(), 7), SUBDATE(CURDATE(), 1); -- 下周 SELECT ADDDATE(CURDATE(), 1), ADDDATE(CURDATE(), 7); -- 当周第一天即星期一 SELECT DATE(CURDATE() - INTERVAL WEEKDAY(CURDATE()) DAY); -- 或 SELECT SUBDATE(CURDATE(), WEEKDAY(CURDATE())); -- 当周最后一天即星期天 SELECT ADDDATE(CURDATE(), (6 - WEEKDAY(CURDATE()))); -- 当前周的序号 SELECT WEEK(CURDATE()); -- 当天在当周的序号 SELECT WEEKDAY(CURDATE()); -- 上周第一天即星期一 SELECT DATE(CURDATE() - INTERVAL WEEKDAY(CURDATE()) DAY - INTERVAL 1 WEEK); -- 或 SELECT SUBDATE(CURDATE(), WEEKDAY(CURDATE()) + 7); -- 上周最后一天即星期天 SELECT ADDDATE(CURDATE(), -1 - WEEKDAY(CURDATE()));
The text was updated successfully, but these errors were encountered:
No branches or pull requests
The text was updated successfully, but these errors were encountered: