Archives of the TeradataForum
Message Posted: Thu, 11 Apr 2013 @ 12:55:05 GMT
I have a question regarding TIME addition
I know we can perform arithmetic operations with TIME and INTERVALS. We can also perform Time subtraction as follows:
select (TIME '12:12:12' - TIME '03:03:03') HOUR;
However why can't we perform addition operation as follows
select (TIME '12:12:12' + TIME '03:03:03') HOUR;-? Fails
Am I doing something that is illogical?
Can anyone please help.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|