Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Constant ExpressionsCertain expressions that return a fixed value are called constant expressions. These include variant function operators that read the system clock, but that are valid in contexts where literal constants are also valid.
Literal INTERVAL A literal INTERVAL specifies the value of an INTERVAL data type, including its qualifying time-units.

Literal INTERVAL

A literal INTERVAL specifies the value of an INTERVAL data type, including its qualifying time-units.

The following examples each use a literal INTERVAL as an expression:

INSERT INTO manufact VALUES ('CAT', 'Catwalk Sports', 
   INTERVAL (16) DAY TO DAY);

SELECT lead_time + INTERVAL (5) DAY TO DAY FROM manufact;

The second example adds five days to each value of lead_time selected from the manufact table.

For more information, see Literal INTERVAL.