当前位置：网站首页>MySQL time function query

MySQL time function query

2022-04-23 04:42:00 【Mount MONI】

# Query the data generated yesterday 

SELECT * FROM org_user WHERE TO_DAYS( NOW( ) ) - TO_DAYS(insert_time) <= 1;

# Query near 7 Data generated in days 

SELECT * FROM org_user where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(insert_time);

# Query near 30 Data generated in days 

SELECT * FROM org_user where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(insert_time);

# Query the data generated this month 

SELECT * FROM org_user WHERE DATE_FORMAT(insert_time, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' );

# Query the data generated last month  

SELECT * FROM org_user WHERE PERIOD_DIFF( date_format( now( ) , '%Y%m' ) , date_format(insert_time, '%Y%m' ) ) = 1;

 

版权声明
本文为[Mount MONI]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220558292452.html

边栏推荐

猜你喜欢

随机推荐