“从字符串转换日期和/或时间时转换失败” [英] "Conversion failed when converting date and/or time from character string"

问题描述

我的存储过程如下：

My stored procedure is as follows,

 -- Add the parameters for the stored procedure here
@FromDate datetime,
@ToDate datetime

    --Select query
   DECLARE @query nvarchar(max)

   set @query='SELECT [col1]
               FROM [Table1]
               WHERE ([col2] BETWEEN '''+@FromDate+''' AND'''+@ToDate+''')'

    execute sp_executesql @query

执行此字符串查询会导致以下错误，



从字符串转换日期和/或时间时转换失败



任何人请帮我解决这个问题

Executing this string query results in following error,

"Conversion failed when converting date and/or time from character string"

Any one please help me to sort this out

推荐答案

您的查询看起来不错......



试试这个：

Your query looks OK...

Try this:

set @query=N'SELECT [col1] 
           FROM [Table1] 
           WHERE ([col2] BETWEEN ''' + @FromDate + ''' AND ''' + @ToDate + ''')'

车通过将其内容打印到MS SQL Managment Studio - 消息窗口来输入参数：

Check the input parameters by printing its content to MS SQL Managment Studio - Messages window:

PRINT @FromDate
PRINT @FromDate

你可以试试这个

Hi, You can try this

@FromDate datetime,
 @ToDate datetime

     --Select query
    DECLARE @query nvarchar(max)

    set @query='SELECT [col1]
                FROM [Table1]
                WHERE ([col2] BETWEEN '''+CONVERT(NVARCHAR, @FromDate,21)+''' AND'''+CONVERT(NVARCHAR, @ToDate, 21)+''')'

     execute sp_executesql @query

这篇关于“从字符串转换日期和/或时间时转换失败”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！