昏。。丢丑了是这样的: select dateadd(Hour,25/60+9,getdate())如果你要加的一小时25分子则如下: select dateadd(Hour,25/60+1,getdate())or:declare @val int set @val=30/60+9 select dateadd(Hour,@val,getdate())
declare @date1 varchar(10),@date2 datetime set @date1='9:30' set @date2='2003-12-01 08:00' select @date1,@date2 select dateadd(MI,datepart(MI,cast(@date1 as datetime)),dateadd(HH,datepart(HH,cast(@date1 as datetime)),@date2))
如下:
dateadd(Hour,9(分钟/60),getdate())
select dateadd(Hour,30/60*9,getdate())如果你要加的一小时25分子则如下:
select dateadd(Hour,25/60*9,getdate())
select dateadd(Hour,25/60+9,getdate())如果你要加的一小时25分子则如下:
select dateadd(Hour,25/60+1,getdate())or:declare @val int
set @val=30/60+9
select dateadd(Hour,@val,getdate())
set @date1='9:30'
set @date2='2003-12-01 08:00'
select @date1,@date2
select dateadd(MI,datepart(MI,cast(@date1 as datetime)),dateadd(HH,datepart(HH,cast(@date1 as datetime)),@date2))
---------- ---------------------------
9:30 2003-12-01 08:00:00.000(1 row(s) affected)
---------------------------
2003-12-01 17:30:00.000
set @yourtime='2003/12/1 08:00:000'
select @yourtime + 1*9.5/24