0
Hi,
Try this..
Select * from Order where date between '1/1/2013' and '9/1/2013'
Note:-Date must be in proper format ('mm/dd/yyyy' or 'yyyy/mm/dd')
0
Select * from tablename where [Date] between Date1 and Date2
e.g. Date1 = '06/04/2012'
Date2 = '06/10/2012'
Hope it will help you.
0
Hi
SELECT * FROM tablename WHERE column_name BETWEEN '11/17/2013' AND '19/12/2012`