
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:
NotesResultData typeOperatorData type
The number represents the
number of seconds between two
NumberTimeminus (-)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.
TimeNumber+ 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
NumberDateTimeminus (-)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.
DateTimeNumber+ or -DateTime
Using Comparison Operators with Time and Time/Date Data Types
MapInfo Professional 12.5248
Querying Your Data in MapInfo Professional
Kommentare zu diesen Handbüchern