从MYSQL的Now()中选择最近7天 [英] Selecting the last 7 days from Now() in MYSQL
本文介绍了从MYSQL的Now()中选择最近7天的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
谢谢您抽出宝贵的时间来回答我的问题.
Thankyou for taking the time to look at my question.
我有这个MYSQL查询:
I have this MYSQL query:
foreach( $wpdb->get_results(
"SELECT wp_pixelcart_calendar.datefield AS DATE,
IFNULL(SUM(wp_pixelcart_daily_sales.quantity),0) AS total_sales
FROM wp_pixelcart_daily_sales RIGHT JOIN wp_pixelcart_calendar ON (DATE(wp_pixelcart_daily_sales.order_date) = wp_pixelcart_calendar.datefield)
WHERE (wp_pixelcart_calendar.datefield BETWEEN (SELECT MIN(DATE(order_date)) FROM wp_pixelcart_daily_sales) AND (SELECT MAX(DATE(order_date)) FROM wp_pixelcart_daily_sales))
GROUP BY DATE"
) as $key => $row) {
echo "<br>". $row->DATE . "',". $row->total_sales . "],";
}
在查询中,我很难显示从现在开始的最近7天,我一直在玩:
I'm having a hard time to display the last seven days from now in the query, ive been playing around with:
BETWEEN (SELECT MIN(DATE(order_date)) FROM wp_pixelcart_daily_sales) AND (SELECT MAX(DATE(order_date)) FROM wp_pixelcart_daily_sales))
对此:
BETWEEN NOW() FROM wp_pixelcart_daily_sales) AND DATE_ADD(NOW(), INTERVAL 7 DAY) FROM wp_pixelcart_daily_sales))
但这似乎不起作用.
任何帮助表示赞赏.
谢谢
推荐答案
如果该方法不起作用,则返回0个结果,请考虑交换日期范围:
if this is not working, returning 0 results, consider swapping the dates' range:
BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW()
这篇关于从MYSQL的Now()中选择最近7天的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文