弄乱了日期范围的情况 [英] mess-up with date range situation
问题描述
我在我的数据库中有以下字段
ID Rec_Month Rec_Year
1 01 2012
2 02 2012
3 02 2011
4 04 2012
5 05 2011
6 06 2012
7 06 2012
在我的表格中有两个日期时间选择器,我可以从中选择日期范围,并希望显示该日期范围内存在的记录
假设我选择此日期范围15-03-2012至30-06-2012
所以我需要以下输出
ID Rec_Month Rec_Year
4 04 2012
6 06 2012
7 06 2012
有谁能指导我怎么去?
提前致谢。
参考我已经面对这个问题
Sql server 2005之间的条款与日期 [ ^
i have this following field in my database
ID Rec_Month Rec_Year
1 01 2012
2 02 2012
3 02 2011
4 04 2012
5 05 2011
6 06 2012
7 06 2012
in my form there is two datetime picker from which i can select date range and want to display records which exists in that date range
suppose i select this date range 15-03-2012 to 30-06-2012
so that i need this following output
ID Rec_Month Rec_Year
4 04 2012
6 06 2012
7 06 2012
can anyone please guide me how to go?
Thanks in advance.
Refer This I have Faced this issue
Sql server 2005 between clause with date[^]
这篇关于弄乱了日期范围的情况的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!