我想以正确的方式编写此查询吗? [英] I want to write this query in the correct way?

问题描述

SELECT * 
FROM 
    tblPickupDetails 
WHERE 
    (Recivedtime 
     BETWEEN 
         '" + FromDate + "00:00:00.000" + "'  AND '" + Todate + "23:59:59.999"+ "')

我需要以正确的方式编写此查询吗?

我认为以下陈述是错误的.

I need to write this query in correct way ?

I think following statement is wrong.

(Recivedtime 
 BETWEEN 
     '" + FromDate + "00:00:00.000" + "'  AND '" + Todate + "23:59:59.999"+ "')

推荐答案

我认为这在查询之间是正确的.
我想知道是否以下查询帮助

I think this between query is correct.
I wonder if following query help

SELECT * 
FROM tblPickupDetails 
WHERE 
CONVERT(VARCHAR(10) ,Recivedtime ,101) >= CONVERT(VARCHAR(10) ,@FromDate,101)
CONVERT(VARCHAR(10) ,Recivedtime ,101) <= CONVERT(VARCHAR(10) ,@ToDate,101)

-Milind

-Milind

这篇关于我想以正确的方式编写此查询吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！