Thread: compare?
View Single Post
  #2 (permalink)  
Old 01-17-2008, 11:18 AM
Unregistered
 
Posts: n/a
Thumbs up 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))
Edit/Delete Message Reply With Quote