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






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

1.Shorthand for a 101 year and 3 month interval(INTERVAL '101' YEAR)
2.Shorthand for a 101 year and 3 month interval(INTERVAL '101-3' YEAR TO MONTH)
3.Shorthand for a 101 year and 3 month interval(INTERVAL '3' MONTH)
4.This script demonstrates the use of the INTERVAL types
5.An assignment to var2