SQL date related

Question

Hi all i want to take record from table named Tblbatch where batch starting date should be from augest 2007 to july 2010... I want to fetch such records which came in between this two dates

Answer 1

Select * from Tblbatch where startDate between '01-08-2007' and '31-07-2010'

• provided you have a datetime column "startDate"

Note : that using between includes both the dates specified. If you want to avoid the dates either change the boundary dates to + - 1 respectively or use > and < conditions