How to add time in sqlserver?

Question

I've two coloumns named Time_In and Grace_Time,which is in time format.I want to add these two columns. I've used '+' operator but it doesnt works.Im getting the error like this

Operand data type time is invalid for add operator.

How can i do it??

Pitsanu Swangpheaw · Accepted Answer · 2013-01-19 07:13:10Z

1

you need to cast them to datetime before add

CAST(Time_In AS DATETIME) + CAST(Grace_Time AS DATETIME)

answered Jan 19, 2013 at 7:13

Pitsanu Swangpheaw

6724 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add time in sqlserver?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related