Literal INTERVAL

The following examples show 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 statement in the preceding example adds five days to each value of lead_time selected from the manufact table.

For more information, see Literal INTERVAL.