c# - SQL Server中如何获取同一日期之间的记录

Question

当我将“开始”和“结束”日期定义为相同的值时，查询不会返回任何行。当我为“截止”日期选择额外的一天时，将返回行。

string FrmDt = frmtx.Text.Trim();// 9/1/2015
string ToDt = totx.Text.Trim();//9/1/2015

select 
    rn.*,
    (select count(reue) as RequtNo 
     from tblests 
     left join aspne u on r.custorid = u.userid 
     left join aspnethip a on  u.Used=a.UserId
     where 
         u.refere = rn.refid 
         and r.Compy = 'bbb' 
         and create >= '9/1/2015'
         and create <= '9/1/2015') as refcount 
from 
    tbl_reference rn

数据类型:[Createte] [datime] NOT NULL

如何将 9/1/2015 12:00:00 AM 转换为 9/1/2015 11:59:59 PM？

Answer 1

你可以像这样简单地使用它:

 createdate >=  '9/1/2015 00:00:00'and createdate <=  '9/1/2015 23:59:59'

否则您可以切换到第二天并删除 =来自 <=

createdate >=  '9/1/2015'and createdate <  '9/2/2015'

要为您的约会添加时间，您可以这样尝试:

DateTime frmDt = new DateTime(2015, 09, 01); //time is 00:00:00 by default
DateTime toDt = new DateTime(2015, 09, 01);
TimeSpan toDtTime = TimeSpan.Parse("23:59:59");
DateTime toDtFinal = toDt.Add(ToDtTime);