【MySQL】关于时间的查询,比如本月,本年,本季度
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了【MySQL】关于时间的查询,比如本月,本年,本季度,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2638字,纯文字阅读大概需要4分钟。
内容图文
mysql查询本季度 -- 今天 select * from ticket_order_detail where to_days(use_time) = to_days(now()); -- 7天 SELECT *FROM ticket_order_detail where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date( use_time) -- 近30天 SELECT *FROM ticket_order_detail where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date( use_time) -- 本月 SELECT *FROM ticket_order_detail WHERE DATE_FORMAT( use_time, ‘%Y%m‘ ) = DATE_FORMAT( CURDATE( ) , ‘%Y%m‘ ) -- 上一月 SELECT *FROM ticket_order_detail WHERE PERIOD_DIFF( date_format( now( ) , ‘%Y%m‘ ) , date_format( use_time, ‘%Y%m‘ ) ) =1 #查询本季度数据 select * from `ticket_order_detail` where QUARTER(use_time)=QUARTER(now()); #查询上季度数据 select * from `ticket_order_detail` where QUARTER(use_time)=QUARTER(DATE_SUB(now(),interval 1 QUARTER)); #查询本年数据 select * from `ticket_order_detail` where YEAR(use_time)=YEAR(NOW()); #查询上年数据 select * from `ticket_order_detail` where year(use_time)=year(date_sub(now(),interval 1 year)); -- 查询当前这周的数据 SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,’%Y-%m-%d’)) = YEARWEEK(now()); -- 查询上周的数据 SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,’%Y-%m-%d’)) = YEARWEEK(now())-1; -- 查询当前月份的数据 select name,submittime from enterprise where date_format(submittime,’%Y-%m’)=date_format(now(),’%Y-%m’) -- 查询距离当前现在6个月的数据 select name,submittime from enterprise where submittime between date_sub(now(),interval 6 month) and now(); -- 查询上个月的数据 select name,submittime from enterprise where date_format(submittime,’%Y-%m’)=date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH),’%Y-%m’) select*from`user`whereDATE_FORMAT(pudate,‘%Y%m‘)=DATE_FORMAT(CURDATE(),‘%Y%m‘) ; select * from user where WEEKOFYEAR(FROM_UNIXTIME(pudate,’%y-%m-%d’)) = WEEKOFYEAR(now()) select* fromuser whereMONTH(FROM_UNIXTIME(pudate,‘%y-%m-%d‘))=MONTH(now()) select* from[user] whereYEAR(FROM_UNIXTIME(pudate,‘%y-%m-%d‘))=YEAR(now()) andMONTH(FROM_UNIXTIME(pudate,‘%y-%m-%d‘))=MONTH(now()) select* from[user] -- wherepudatebetween上月最后一天 -- and下月第一天 where date(regdate) = curdate(); select * from test where year(regdate)=year(now()) and month(regdate)=month(now()) and day(regdate)=day(now()) SELECT date( c_instime ) ,curdate( ) FROM `t_score` WHERE 1 LIMIT 0 , 30
【MySQL】关于时间的查询,比如本月,本年,本季度
标签:rda mon 时间 ebe between period uart ticket rem
本文系统来源:http://www.cnblogs.com/flydkPocketMagic/p/7089324.html
内容总结
以上是互联网集市为您收集整理的【MySQL】关于时间的查询,比如本月,本年,本季度全部内容,希望文章能够帮你解决【MySQL】关于时间的查询,比如本月,本年,本季度所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。