CODEWITHSUNDEEP
sql-server
Amit Patil
Amit Patil

Reputation: 1993

SQL date related

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

Upvotes: 0

Views: 43

Answers (1)

Jagmag
Jagmag

Reputation: 10356

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

Upvotes: 3

Related Questions