java查询时间代码实现

小果子^_^

已于 2022-08-01 20:57:27 修改

阅读量329

点赞数

分类专栏： Java 文章标签： mysql

于 2019-10-15 17:08:06 首次发布

本文链接：https://blog.csdn.net/weixin_44021888/article/details/102570661

版权

Java 专栏收录该内容

88 篇文章 1 订阅

订阅专栏

查询时间：当月时间，最近一周、、、

当天数据

SELECT * FROM course_order WHERE campus_id = 1 AND order_type = 3 AND status = 3 OR status=4 AND DATE(pay_time) = CURDATE()

本周数据

SELECT * FROM course_order WHERE campus_id = 1 AND order_type = 3 AND status = 3 OR status=4 AND YEARWEEK(DATE_FORMAT(pay_time,‘%Y-%m-%d’)) = YEARWEEK(NOW())

当前月份

SELECT * FROM course_order WHERE campus_id = 1 AND order_type = 3 AND status = 3 OR status=4 AND DATE_FORMAT(pay_time,‘%Y-%m’)=DATE_FORMAT(NOW(),‘%Y-%m’)

查询每个月的数据

SELECT * FROM course_order WHERE DATE_FORMAT(pay_time,‘%Y-%m’)= ‘2019-07’

查询近7天的数据(不包括当天的前7天)

SELECT * FROM course_order WHERE
AND DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(pay_time)

查询近7周的数据（不包括当天的前7周）

SELECT * FROM course_order WHERE
AND DATE_SUB(CURDATE(), INTERVAL 49 DAY) <= date(pay_time)
######查询近7个月的数据
SELECT * FROM course_order WHERE DATE_FORMAT(pay_time,‘%m’) BETWEEN
(SELECT MONTH(DATE_SUB(CURDATE(),INTERVAL 6 month))) AND MONTH(CURDATE());