Databases Reporting with SQL Date and Time Functions Calculating Dates

Gurdeep singh
Gurdeep singh
1,522 Points

SELECT COUNT(*) AS "ordered_yesterday_and_shipped" FROM orders WHERE status = "shipped" AND ordered_on = DATE("now", -1)

I want to know what's wrong with this code kindly help.

2 Answers

Steven Parker
Steven Parker
202,085 Points

You didn't specify a unit for the date modifier. Try this:

DATE("now", "-1 day")
Gurdeep singh
Gurdeep singh
1,522 Points

Ohh show silly thank you for helping!