从字符串向datetime转换时失败SQL 2005 declare @StartDate datetime,@EndDate dateTimeselect @tsql @t
从字符串向datetime转换时失败
SQL 2005
declare @StartDate datetime,
@EndDate dateTime
select @tsql = @tsql + ' and a.UP_Time between ' + @StartDate + ' and ' + @EndDate
上述是时间比较的问题。编译没报错，执行就报错“从字符串向datetime转换时失败”
哪里写错了？
[解决办法]
'"++"'
[解决办法]
DECLARE @tsql NVARCHAR(max)
SET @tsql=''
declare @StartDate DATETIME='2013-04-26 00:00:01',
@EndDate dateTime ='2013-04-26 15:00:01'
--PRINT CONVERT(VARCHAR(30),@StartDate,120)
--PRINT CONVERT(VARCHAR(30),@EndDate,120)
SELECT @tsql =@tsql+ ' and a.UP_Time between ' +''''+CONVERT(VARCHAR(30),@StartDate,120)+'''' +' and ' +''''+CONVERT(VARCHAR(30),@EndDate,120)+''''
print @tsql