INTERVAL DAY TO SECOND : INTERVAL « Data Type « Oracle PL / SQL

1. Oracle PL / SQL
2. Data Type
3. INTERVAL

INTERVAL DAY TO SECOND

  
SQL>
SQL> declare
  2    t1   timestamp := current_timestamp + 1 ;
  3    i1  INTERVAL DAY TO SECOND;
  4  begin
  5    i1 := t1 - current_timestamp;
  6    dbms_output.put_line(i1);
  7  end;
  8  /
+00 23:59:59.640000

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>

   
    
  

Related examples in the same category