| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
01-17-2008, 11:18 AM
|
|||
|
|||
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))     
|
SQL 92 dialect question:
