select cast(CONVERT(varchar(10),@放日期的变量,120)+' '+convert(char(8),@放时间的变量,114) as datetime)
呵呵 你看一下convert 的help就知道120,114的含义了
看看这个: select CAST(CAST(@t1 AS int) + @t2 - CAST(@t2 AS int) AS datetime)
更正: declare @t1 as datetime declare @t2 as datetime set @t1='2003-01-30 19:00:00' set @t2='2001-01-01 8:23:00' select cast(floor(cast(@t1 as real))+@t2-floor(cast(@t2 as real)) as datetime)
select CAST(CAST(@t1 AS int) + @t2 - CAST(@t2 AS int) AS datetime)
declare @t1 as datetime
declare @t2 as datetime
set @t1='2003-01-30 19:00:00'
set @t2='2001-01-01 8:23:00'
select cast(floor(cast(@t1 as real))+@t2-floor(cast(@t2 as real)) as datetime)
以前常这样做!