mysql查询本年本周等

最新推荐文章于 2023-06-09 11:15:26 发布

不懂bug

最新推荐文章于 2023-06-09 11:15:26 发布

阅读量253

点赞数

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/qq_41846661/article/details/125395982

版权

关键词由优快云通过智能技术生成

2 篇文章

订阅专栏

本文介绍了多种SQL查询语句，用于高效地筛选数据在特定日期范围内的记录，包括当天、昨天、近7天、近30天、本月、上个月、本季度、上季度以及今年的数据。这些查询对于数据分析和报表生成非常实用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select * from sys_user  where to_days(create_time) = to_days(now());

select * from sys_user where to_days( now( ) ) - to_days( create_time) <= 1

select * from sys_user where date_sub(curdate(), interval 7 day) <= date(create_time)

select * from 表名 where date_sub(curdate(), interval 30 day) <= date(create_time)

select * from sys_user where date_format(create_time,'%y%m') = date_format(curdate(),'%y%m')

select * from sys_user where period_diff( date_format( now( ) , '%y%m' ) , date_format( create_time, '%y%m' ) ) =1

select * from sys_user where QUARTER(create_date)=QUARTER(now());

select * from sys_user where QUARTER(create_date)=QUARTER(DATE_SUB(now(),interval 1 QUARTER));

select * from sys_user where year(create_date)=year(date_sub(now(),interval 1 year));

SELECT * FROM sys_user WHERE YEARWEEK(date_format(create_time,'%Y-%m-%d')) = YEARWEEK(now());

SELECT * FROM enterprise WHERE YEARWEEK(date_format(create_time,'%Y-%m-%d')) = YEARWEEK(now())-1;