日期时间问题：如何将一个日期如2007-07-10后加上我指定的时间

[wanghan226]

如何将一个日期2007-07-10后加上我指定的时间结果：'2007-07-10 07:00:00'.

[kk19840210]

cast(2007-07-10 as varchar)+' 07:00:00'

[gahade]

declare @sj varchar(20)
set @sj='07:00:00'
select cast('2007-07-10'+' '+@sj as datetime)

[kk19840210]

cast(2007-07-10 as varchar(20))+' 07:00:00'

[leo_lesley]

DECLARE @STR VARCHAR(30)
SELECT @STR='2007-07-10'

SELECT CAST(@STR+' 07:00:000' AS DATETIME)

[肥胖的柠檬]

select dateadd(hh,7,'2007-07-10')

[fa_ge]

cast(2007-07-10 as varchar)+' 07:00:00'

[青锋-SS]

dateadd(0

[wanghan226]

谢谢，那datetime中提取time时间怎么提取?

[青锋-SS]

select convert(char,getdate(),8)

[青锋-SS]

具体用法参考convert()的帮助

[ivan_ren]

获取time部分
select convert(varchar(20),getdate(),108)

[wanghan226]

结帐