TIMEDIFF(t,s)
TIMEDIFF(t,s)
is a time function that calculates the time value between a start and
end time.
t and s values: When
used in a function, the expressions t
and s
must
supply a time
value, a time
stamp value or an alphanumeric value that matches the current time
or time stamp format. The arguments must have the same data type, in other
words, be either a time value or a time stamp value.
t, s |
Result of the TIMEDIFF(t,s) Function |
|---|---|
Positive difference between |
Time value |
|
Dates in the time stamp value are used to calculate |
Difference of more than |
Number of hours modulo |
|
|