你可以尝试这样的事情......

You can try some thing like this...

Declare @Year varchar ='2013', @Month varchar ='7', @Day varchar ='1'
Select Convert(Date, @Year+'-'+@Month +'-'+ @Day)-- Any Version
SELECT DATEFROMPARTS(2012,7,1)  -- For Sql Server 2012 and Above

DateFromParts-MSDN

转换和转换

转换W3Schools

谢谢大家我自己解决了.......



使用此代码..



选择CAST（CAST（@ToYear AS varchar）+' - '+ CAST（@ToMonth AS varchar）+' - '来自T_PayBill的ToDate + CAST（1 AS varchar）AS DATE

thanks guys i solved it myself.......

with this code..

select CAST(CAST(@ToYear AS varchar) + '-' + CAST(@ToMonth AS varchar) + '-' + CAST(1 AS varchar) AS DATE) as ToDate from T_PayBill