ALLBASE/SQL Reference Manual (36216-90216)

218 Chapter7
Data Types
Date/Time Operations
INTERVAL values:
UPDATE ManufDB.TestData
SET LabTime = '5 04:23:00.000'
WHERE TestEnd = '19:30:00'
Note that the radix of DATE and TIME data is seconds, whereas the radix of DATETIME
and INTERVAL data is milliseconds.
Date/time data types can also be converted to formats other than the default formats by
the date/time functions described in Chapter 8 , “Expressions.”
Use of Date/Time Data Types in Arithmetic Expressions
You can use a variety of operations to increment, decrement, add or subtract date, time,
datetime, and interval values. Table 7-5. shows the valid operations and the data type of
the result:
Table 7-5. Arithmetic Operations on Date/Time Data Types
Operanda Operator Operand b Result Type
DATE +,− INTERVAL DATE
INTERVAL + DATE DATE
DATE − DATE INTERVAL
TIME +,− INTERVAL TIME
INTERVAL + TIME TIME
TIME − TIME INTERVAL
DATETIME +,− INTERVAL DATETIME
INTERVAL + DATETIME DATETIME
DATETIME − DATETIME INTERVAL
INTERVAL +,− INTERVAL INTERVAL
INTERVAL *, / INTEGER INTERVAL
STRING
a
− DATE INTERVAL
STRING
b
+ DATE DATE
DATE − STRINGa INTERVAL
DATE + STRINGb DATE
STRING
c
− DATETIME INTERVAL
DATETIME − STRINGc INTERVAL
STRINGb + DATETIME DATETIME
DATETIME + STRING DATETIME