“从字符串转换日期和/或时间时转换失败” [英] "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屋!
查看全文