MySQL查询当天当月数据

蔚落 2022-07-11 01:52 189阅读 0赞

**今天**

select \* from 表名  where to\_days(时间字段名) = to\_days(now());

**昨天**

SELECT \* FROM 表名  WHERE TO\_DAYS( NOW( ) ) \- TO\_DAYS( 时间字段名)  <= **1**

**近7天**

SELECT \* FROM 表名  where DATE\_SUB(CURDATE(), INTERVAL **7** DAY) <= date(时间字段名)

**近30天**

SELECT \* FROM 表名  where DATE\_SUB(CURDATE(), INTERVAL **30** DAY) <= date(时间字段名)

**本月**

SELECT \* FROM 表名  WHERE DATE\_FORMAT( 时间字段名, '%Y%m' )  = DATE\_FORMAT( CURDATE( ) , '%Y%m' )

**上一月**

SELECT \* FROM 表名  WHERE PERIOD\_DIFF( date\_format( now( ) , '%Y%m' ) ,date\_format( 时间字段名, '%Y%m' ) ) =**1**

**查询本季度数据**

select \* from \`ht\_invoice\_information\` where QUARTER(create\_date)=QUARTER(now());

**查询上季度数据**

select \* from \`ht\_invoice\_information\` where QUARTER(create\_date)=QUARTER(DATE\_SUB(now(),interval **1** QUARTER));

**查询本年数据**

select \* from \`ht\_invoice\_information\` where YEAR(create\_date)=YEAR(NOW());

**查询上年数据**

select \* from \`ht\_invoice\_information\` where year(create\_date)=year(date\_sub(now(),interval **1**  year));

**查询当前这周的数据**

SELECT name,submittime FROMenterprise WHERE YEARWEEK(date\_format(submittime,'%Y-%m-%d')) = YEARWEEK(now());

**查询上周的数据**

SELECT name,submittime FROMenterprise WHERE YEARWEEK(date\_format(submittime,'%Y-%m-%d')) = YEARWEEK(now())\-**1**;

**查询上个月的数据**

select name,submittime fromenterprise where date\_format(submittime,'%Y-%m')=date\_format(DATE\_SUB(curdate(), INTERVAL **1**  MONTH),'%Y-%m')

select \* from  user where DATE\_FORMAT(pudate,'%Y%m') = DATE\_FORMAT(CURDATE(),'%Y%m') ;

select \* from  user where WEEKOFYEAR(FROM\_UNIXTIME(pudate,'%y-%m-%d')) = WEEKOFYEAR(now())

select \* from  user where MONTH(FROM\_UNIXTIME(pudate,'%y-%m-%d')) = MONTH(now())

select \* from  user where YEAR(FROM\_UNIXTIME(pudate,'%y-%m-%d')) = YEAR(now())  and MONTH(FROM\_UNIXTIME(pudate,'%y-%m-%d')) = MONTH(now())

select \* from  user where pudate  between  上月最后一天 and 下月第一天

**查询当前月份的数据 **

select name,submittime fromenterprise   wheredate\_format(submittime,'%Y-%m')=date\_format(now(),'%Y-%m')

**查询距离当前现在6个月的数据**

select name,submittime fromenterprise where submittime betweendate\_sub(now(),interval **6** month) and now();

MySQL查询当天当月数据

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 oracle查询日期为当天的数据sql

相关 mysql 查询当天、本周，本月，上一个月的数据

相关 mysql查询当天或者几天内的数据

相关 MySQL查询当天、昨天、近3天的数据

相关 Mysql查询当天,本周,本月所有数据记录

相关 MySQL查询小于或大于当天日期的数据

相关 MySQL查询当天当月数据

相关 mysql 查询当天数据

相关 mysql 查询当日，昨日，当月，当季度，上一季度和当天某一时间段的数据

相关 Mysql查询的一些操作(查表名，查字段名，查当月，查一周，查当天)