Oracle: date - date

[Ladislav Pavlič]

declare a date; b date; c interval; begin a:=sysdate; b:=sysdate-1; c:=
a-b;end;


Použijte tuto sysntaxi:

declare
a date;
b date;
c INTERVAL DAY(3) TO SECOND(3);
begin
  a := sysdate;
  b := sysdate-1.004;
  c := (a-b) DAY TO SECOND;
  -- dbms_output.put_line(c); -- pro overeni
end;