SELECT
SUM(ReceiptDetails.ItemSellPrice * ReceiptDetails.ItemQty) AS TotalSalesForToday
FROM
(ReceiptDetails
INNER JOIN
Receipt ON ReceiptDetails.ReceiptID = Receipt.ReceiptID)
WHERE
(Receipt.ReceiptDate =?)
使用该DATE()
功能。
如果该值确实是一个日期,那么直接比较将起作用:
WHERE Receipt.ReceiptDate = DATE()
如果ReceiptDate
也有时间分量,则:
WHERE Receipt.ReceiptDate >= DATE() AND
Receipt.ReceiptDate < DATEADD("day, 1, DATE())
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句