Date Search in SQL Server.

Question

Hi friends I want to know how to perform date search in SQL Server. Thank you.

MuthuMari M · Answer

Hi you can search like this. 1. SELECT * FROM events e WHERE (@startDate BETWEEN e.startDate and e.endDate) OR (@endDate BETWEEN e.startDate and e.endDate) OR (@startDate e.endDate) 2. SELECT * FROM vtest WHERE resultdate = 2010-10-08; 3. SELECT * FROM DateSample WHERE DateVal BETWEEN '2002-02-28' AND '2002-02-28 23:59:59.997' 4. SELECT DATEDIFF ( YEAR  '2011-12-31 23:59:59'  '2012-01-01 00:00:00' ) AS YEAR_DIFF thanks. If this post is useful then mark it as  Accepted Answer

Senthilkumar · Answer

Hi Vipendra Please refer these articles. http://www.securitypronews.com/it/database/spn-20-20031023HowtoSearchforDateandTimeValuesUsingMicrosoftSQLServer2000.html http://www.devarticles.com/c/a/SQL-Server/Date-and-Time-Values-Using-SQL-Server-2000/

Satyapriya Nayak · Answer

Hi Vipendra Please refer the below link http://www.securitypronews.com/it/database/spn-20-20031023HowtoSearchforDateandTimeValuesUsingMicrosoftSQLServer2000.html Thanks

Kunal Vaishya · Answer

Dear You can search by like this WHERE DateDiff(dd OrderDate '01/01/2006') = 0 WHERE Convert(varchar(20) OrderDate 101) = '01/01/2006' WHERE Year(OrderDate) = 2006 AND Month(OrderDate) = 1 and Day(OrderDate)=1 WHERE OrderDate LIKE '01/01/2006%' WHERE OrderDate >= '01/01/2006' AND OrderDate