ANY answer.
Re: compare?
//For Day
SELECT PkgDate, ExpDate
FROM TableName
WHERE (DAY(PkgDate) = DAY(ExpDate))
//For Year
SELECT PkgDate, ExpDate
FROM TableName
WHERE (Year(PkgDate) = Year(ExpDate))
//For Month
SELECT PkgDate, ExpDate
FROM TableName
WHERE (month(PkgDate) = month(ExpDate))
|