Loading

SQL command to select list attended people particular month!

Santosh Ch

10y1.1kSQL

I am working in sql server management studio 2008 I applied following query:

select * from AllInOneTable2 where Date>='1-03-2016' AND Date<='31-03-2016'

This giving me the list of rows but this query also including the 05 month and other month details which I don't want I want only 03 month details. So I stuck here I don't know what is my mistake. Please help and advice experts!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sonu Chaudhary10y ago
Accepted answer
dear Santosh you cab use between clauseit will work fine for me.

select * from AllInOneTable2
where
Date between '2016/03/01' and '2016/03/31'
+1
Nitin Sontakke8y ago
While communicating with computers always use date format yyyy-MM-dd.
0
Sreedhar Kusuma8y ago
SELECT *
FROM AllInOneTable2
WHERE Date BETWEEN CAST('01-Mar-2016' as DATETIME) AND CAST('31-Mar-2016')
0