I Have table in sql server 2000 and query
select * from Contact where Hir_Date=sysdate
Hirdate is datetime
but it gives error . Is there any possible option to retrieve data from sql server using current date
i Know one query
select getdate() as current_Date but how can link this query with above query