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.
Built-in routinesUse build-in routines in SQL statements to perform specialized tasks.
Interval functionsUse the interval functions to return an INTERVAL value from arguments that include a number and a character-string representing time units and separators in INTERVAL qualifiers. These functions are useful in CREATE TABLE, CREATE INDEX, and ALTER FRAGMENT statements that define or modify range-interval distributed storage strategies for indexes and tables.

Interval functions

Use the interval functions to return an INTERVAL value from arguments that include a number and a character-string representing time units and separators in INTERVAL qualifiers. These functions are useful in CREATE TABLE, CREATE INDEX, and ALTER FRAGMENT statements that define or modify range-interval distributed storage strategies for indexes and tables.

Interval functions convert a number or a string to an INTERVAL DAY TO SECOND or INTERVAL YEAR TO MONTH literal, or of whatever valid precision the time units in the second argument specify. These functions do not, however, support FRACTION or .FRACTION as the last time unit in their second argument.