如何选择从日期开始的记录,并在两个日期之间进行记录,但是缺少(最后) [英] How to select record where from date and todate between two dates but todate(last) missing
问题描述
嗨朋友,
查询缺少最后一天的记录。
我的查询是这样的..
选择 DATEADD(dd, 0 ,DATEDIFF(dd, 0 ,SubmittedOn)) as WorkingDate,DATENAME(dw,SubmittedOn) as DaName,
ClientID,EmployeeID
来自 dbo.tblEmployeeTimeCards where
- 和SubmittedOn> = @ From AND SubmittedOn< = @到
和 SubmittedOn DATEADD(dd, 0 ,DATEDIFF(dd, 0 , @ From )) AND DATEADD(dd, 0 ,DATEDIFF(dd, 0 , @ To ))
我正尝试不同的方式但是没有得到完美的输出。在我的输出中缺少上次日期记录
fromdate ---''3/29/2013 12:00:00''
todate ---''4/11/2013 23:59:00''
输出
-------- ------
3/29/2013 01:00:00
3/30/2013 01:00:00
4/1/2013 01:00:00
4/2/2013 01:00:00
4/3/2013 01:00:00
4/4/2013 01:00:00
4/10/2013 01:00:00
但不是显示4/11/2013记录
请帮助我..
感谢和问候
试试这个
选择 DATEADD(dd, 0 ,DATEDIFF(dd, 0 ,SubmittedOn)) as WorkingDate,DATENAME(dw,SubmittedOn) as DaName,
ClientID,EmployeeID
来自 dbo.tblEmployeeTimeCards 其中
- 和SubmittedOn> = @ From AND SubmittedOn< = @到
和 转换( datetime ,转换( varchar ( 10 ),SubmittedOn, 103 ))介于 转换( datetime ,转换( varchar ( 10 ), @从, 103 )) AND convert ( datetime , convert ( varchar ( 10 ), @ To , 103 ))
快乐编码!
:)
Hi Friends,
between query missing last day records.
my query like this..
select DATEADD(dd, 0, DATEDIFF(dd, 0,SubmittedOn)) as WorkingDate,DATENAME(dw, SubmittedOn) as DaName,
ClientID,EmployeeID
from dbo.tblEmployeeTimeCards where
--and SubmittedOn >=@From AND SubmittedOn <=@To
and SubmittedOn between DATEADD(dd, 0, DATEDIFF(dd, 0,@From)) AND DATEADD(dd,0, DATEDIFF(dd, 0,@To))
am trying different ways but am not get perfect output. in my output missing last date records
fromdate---''3/29/2013 12:00:00''
todate---''4/11/2013 23:59:00''
output
--------------
3/29/2013 01:00:00
3/30/2013 01:00:00
4/1/2013 01:00:00
4/2/2013 01:00:00
4/3/2013 01:00:00
4/4/2013 01:00:00
4/10/2013 01:00:00
but not showing 4/11/2013 record
please help me..
thanks and regards
Try this
select DATEADD(dd, 0, DATEDIFF(dd, 0,SubmittedOn)) as WorkingDate,DATENAME(dw, SubmittedOn) as DaName, ClientID,EmployeeID from dbo.tblEmployeeTimeCards where --and SubmittedOn >=@From AND SubmittedOn <=@To and convert(datetime,convert(varchar(10),SubmittedOn,103)) between convert(datetime,convert(varchar(10),@From,103)) AND convert(datetime,convert(varchar(10),@To,103))
Happy Coding!
:)
这篇关于如何选择从日期开始的记录,并在两个日期之间进行记录,但是缺少(最后)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!