[SOLVE]I need a SQL command, how to use date minus with system date know its last..

I need a SQL command, how to use date minus with system date know its last 3 day?

how to minus the date to know still have how many day left, but minimum but have 3day.... compare to system date...??

Code:

---

SELECT ProductNo, Gendate from ProductInfo
WHERE Gendate - date() = 3
GROUP BY ProductNo, Gendate

---

Quote:

---

how to minus the date to know still have three more day compare to system date...??

---

Not clear what u are trying? Do you want to deduct 3 days from the system date?

I have already solve it...

Good. :thumb:
But take sometime to post your solution, it might help somebody. ;)