CodingForums.com - View Single Post

JefferyJamison · 10-16-2012, 05:38 AM

Hi! Query to get records between two particular date like 07/08/2012 and 10/08/2012 then use below query:

SELECT * FROM #temp WHERE CONVERT(VARCHAR(10),CrDate,103) BETWEEN CONVERT(VARCHAR(10),'07/08/2012',103) AND CONVERT(VARCHAR(10),'10/08/2012',103)

OR

Syntax Query to get data between any two dates then you use below query :

SELECT Column1,Column2,Column3 FROM TABLENAME WHERE Column3 BETWEEN GetDate()-1 AND GetDate()

10-16-2012, 05:38 AM	PM User \| #14
JefferyJamison New Coder Join Date: Sep 2012 Location: USA Posts: 13 Thanks: 0 Thanked 2 Times in 2 Posts	Hi! Query to get records between two particular date like 07/08/2012 and 10/08/2012 then use below query: SELECT * FROM #temp WHERE CONVERT(VARCHAR(10),CrDate,103) BETWEEN CONVERT(VARCHAR(10),'07/08/2012',103) AND CONVERT(VARCHAR(10),'10/08/2012',103) OR Syntax Query to get data between any two dates then you use below query : SELECT Column1,Column2,Column3 FROM TABLENAME WHERE Column3 BETWEEN GetDate()-1 AND GetDate()