Pitney Bowes MapInfo Professional - Manual (Page 248)

Using Arithmetic Operators with Time and Time/Date Data Types
You can use the addition and subtraction operators with the Time and Time/Date data types as follows:
Notes Result Data type Operator Data type
The number represents the
number of seconds between two Number Time minus (-) Time
times as a floating point number.
The fractional part of the result
represents milliseconds.
The number represents the
seconds to add to the first Time. Time Number + or - Time
The Time wraps around midnight
so that 11:59 PM + 120 seconds
equals 12:01 AM.
The number represents the
number of days between two Number DateTime minus (-) DateTime
DateTimes as a floating point
number. The fractional part of the
result is the fractional portion of
a day, as in today at noon minus
today at midnight equals one half
day.
The number represents the
number of days to add to the first
Time. DateTime Number + or - DateTime
Using Comparison Operators with Time and Time/Date Data Types
MapInfo Professional 12.5 248
Querying Your Data in MapInfo Professional