| Author: Mohan 01 Nov 2009 | Member Level: Diamond | Rating:  Points: 2 |
try this
select * from table where OrderDate>='1/1/2009' and Orderdate<='1/31/2009'
Regards
Mohan Kumar.D
|
| Author: greeny_1984 01 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Hi,
You can check out 'between' operator in sql server to achieve
your functionality.
Regards,
Greeny_1984
Rate this Response[Excellent/Good/Poor]
FRESHERS check this link
Need help from me join here
|
| Author: Melchior 01 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
Instead of using BETWEEN operator,Mohan response is ok.
Because SQL SERVER will transform Between operator into (>= AND <=) format. To improve the performance,don't use costly operator like BETWEEN.
|
| Author: Manick 01 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
select * from table_name where OrderDate BETWEEN 'From_date' and 'To_date'
Regards,
Manick
|
| Author: Shameer 03 Nov 2009 | Member Level: Silver | Rating: Points: 2 |
In some databases, the BETWEEN operator only selects fields that are between and excluding the test values. So instead of BETWEEN use comparison operator(<,>) , you will get the correct answer.
|
| Author: sudha 12 Nov 2009 | Member Level: Silver | Rating: Points: 2 |
SELECT * from [tablename] where date BETWEEN 'from-date' and 'to-date';
|