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.