sql - I want where the "ReceiptDate=? should be the current system date.... and I want to write how to get the current system date in SQL

Question

SELECT        
    SUM(ReceiptDetails.ItemSellPrice * ReceiptDetails.ItemQty) AS TotalSalesForToday
FROM            
    (ReceiptDetails 
INNER JOIN
    Receipt ON ReceiptDetails.ReceiptID = Receipt.ReceiptID)
WHERE
    (Receipt.ReceiptDate =?)

标签： sqlvb.netms-access

Answer 1

使用该DATE()功能。

如果该值确实是一个日期，那么直接比较将起作用：

WHERE Receipt.ReceiptDate = DATE()

如果ReceiptDate还具有时间分量，则：

WHERE Receipt.ReceiptDate >= DATE() AND
      Receipt.ReceiptDate < DATEADD("day, 1, DATE())