SQLServer查询某天数据语法

SQLServer查询当天数据语法

select  * from compare_scan 
				 where 1=1 
				 and  IncomeTime 
				 BETWEEN '2021-9-14' AND dateadd(second,-1,dateadd(day,1,'2021-9-14'))

/*
解释说明:

IncomeTime:列名

BETWEEN '2021-9-14' AND dateadd(second,-1,dateadd(day,1,'2021-9-14')):

表示加一天在减一秒就是这个区间的一天数据

*/

//动态语法调用-------参考(比较low的写法哈)

 string sql = string.Format("select * from compare_scan where 1=1 ");
            if (scan_user != "")
            {
                sql += " and scan_User = '" + scan_user + "'";
            }
           if(timeB != ""|| timeE != "")
            {
                if(timeB!= timeE)
                {
                    if (timeB != "")
                    {
                        sql += " and IncomeTime > '" + timeB + "'";
                    }
                    if (timeE != "")
                    {
                        sql += " and IncomeTime < '" + timeE + "'";
                    }
                }
                else
                {
                    //and  IncomeTime BETWEEN '2021-9-14' AND dateadd(second,-1,dateadd(day,1,'2021-9-14'))
                    sql += " and IncomeTime BETWEEN '" + timeB +"' AND dateadd(second,-1,dateadd(day,1,'"+timeB+"'))  ";
                }
            }
                

            
            


            sql += " order by IncomeTime desc";