DECLARE @Y INT DECLARE @M INT DECLARE @D INTSET @Y = 2008 SET @M = 05 SET @D = 15SELECT CONVERT(DATETIME, CONVERT(VARCHAR(4),@Y)+'-'+CONGERT(VARCHAR(2),@M)+'-'+CONVERT(VARCHAR(2),@D),120)
select CAST(( CAST('2008' as varchar(5)) + CAST('05' as varchar(5)) + CAST('15' as varchar(5))) as datetime)/* ----------------------- 2008-05-15 00:00:00.000(1 行受影响) */
select cast('2008-'+'05-'+'15' as datetime)
DECLARE @Y INT
DECLARE @M INT
DECLARE @D INTSET @Y = 2008
SET @M = 05
SET @D = 15SELECT CONVERT(DATETIME, CONVERT(VARCHAR(4),@Y)+'-'+CONGERT(VARCHAR(2),@M)+'-'+CONVERT(VARCHAR(2),@D),120)
-----------------------
2008-05-15 00:00:00.000(1 行受影响)
*/