如何从特定两个日期之间的表中获取记录 [英] How to get the records from a table in between particular two dates
本文介绍了如何从特定两个日期之间的表中获取记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
实际上在我的表格中我过滤了从日期到日期。例如
Tabel-LoginDetails
userid | loginDate
sai || 13/1/2012
jam | 13/1/2012
sai | 10/2/2012
sai | 11/2/2012
现在我将传递三个参数Userid,FromDate,ToDate(sravi,13/1 / 2012,13 / 2/2012)
怎么写sql查询以下结果
现在我shold得到如下记录
< pre lang = vb > userid | loginDate
sai || 13/1/2012
sai | 10/2/2012
sai | 11/2/2012 < / pre >
解决方案
他们有很多方法可以实现这个目标
1.使用BETWEEN [ ^ ]
选择 userid,loginDate 来自 tblname 其中 loginDate BETWEEN FromDate AND ToDate
2.只需将两个日期与指定的日期进行比较选择 userid,loginDate 来自 tblname 其中 loginDate< = ToDate 和 loginDate> = FromDate
3.使用 DATEDIFF() [ ^ ]返回整数值的函数,即两个日期之间的计数
从LoginDetails中选择userid,loginDate,其中loginDate< = 01/01 / 2013和loginDate> = 01 / 02/2013
Actually in my table i am filtering through From-date and to-date.for example
Tabel-LoginDetails
userid|loginDate
sai ||13/1/2012
jam | 13/1/2012
sai | 10/2/2012
sai | 11/2/2012
Now i will pass three parameters Userid,FromDate,ToDate(sravi,13/1/2012,13/2/2012)
how to write sql query for the below result
now i shold get the records like below
<pre lang="vb">userid|loginDate
sai ||13/1/2012
sai | 10/2/2012
sai | 11/2/2012</pre>
解决方案
Their are many ways of achieving this
1. Use of BETWEEN[^]
select userid,loginDate from tblname where loginDate BETWEEN FromDate AND ToDate
2. Simply compare the two dates with the specified oneselect userid,loginDate from tblname where loginDate<=ToDate and loginDate>=FromDate
3. Use DATEDIFF()[^] function which returns an integer value i.e. count between two dates
select userid,loginDate from LoginDetails where loginDate<=01/01/2013 and loginDate>=01/02/2013
这篇关于如何从特定两个日期之间的表中获取记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文