ADDTIME(t,a) and SUBTIME(t,a) are time functions that calculate a time/time stamp value in the past or future.
Value t: When used in a function, the expression t (time_or_timestamp_expression) must supply a time, a time stamp value, or an alphanumeric value that matches the current time or time stamp format.
Value a: When used in a function, the expression a (time_expression) must supply a time value or an alphanumeric value that matches the current time format.
t, a |
Result of the ADDTIME(t,a)/SUBTIME(t,a) Function |
---|---|
Addition of a to t or subtraction of a from t |
|
SUBTIME(t,a) and t and a are time values |
a must be less than t, otherwise an error is reported |
t or a is a NULL value |
NULL value |