Query to Add two time value in sql server

Kirthiga
Posted by Kirthiga under Sql Server category on | Points: 40 | Views : 1277
Declare @time1 datetime,@time2 datetime
set @time1='3:30:12'
set @time2='1:12:10'
select cast(@time1+@time2 as time)[Time]

Comments or Responses

Login to post response