I have records in sql database table whith contain Date, ID, Name, Amount as colums. So my question is:
Which quary can i use to select son record bettwin Date1 and Date2?
Loading
I have records in sql database table whith contain Date, ID, Name, Amount as colums. So my question is:
Which quary can i use to select son record bettwin Date1 and Date2?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abhay ShankerPosted Nov 6, 2013, 7:28 AM
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')
Pradip PandeyPosted Nov 6, 2013, 6:58 AM
e.g. Date1 = '06/04/2012'
Date2 = '06/10/2012'
Hope it will help you.
Sanjay KumarPosted Nov 6, 2013, 6:32 AM
SELECT * FROM tablename WHERE column_name BETWEEN '11/17/2013' AND '19/12/2012`