Oracle PL/SQL Example 3-6 Assigning Literals to an INTERVAL DAY TO SECOND Variable

Example 3-6 Assigning Literals to an INTERVAL DAY TO SECOND Variable

DECLARE
   lag_time INTERVAL DAY(3) TO SECOND(3);
BEGIN
   lag_time := '7 09:24:30';
   IF lag_time > INTERVAL '6' DAY THEN
     DBMS_OUTPUT.PUT_LINE ( 'Greater than 6 days');
   ELSE
     DBMS_OUTPUT.PUT_LINE ( 'Less than 6 days');
   END IF;
END;
/