how to write querry for expired date

[developerit]

hi, iam using sql server 2000 , the table fields are brabchid nvarchar(50), branchname nvarchar(50), companyid nvarchar(50), startdate datetime, enddate datetime 1)how to write a query to check that enddate is expired . 2)how to write a query to check that enddate is will expired after 10 days please give the example which helps me.

[Mycroft Holmes]

Look into date function

SELECT * FROM TABLE WHERE EndDate < GETDATE()
SELECT * FROM TABLE WHERE DATEDIFF(d,Startdate,EndDate) > 10

Never underestimate the power of human stupidity RAH

[developerit]

thanks for code project team .it helps me alot...