how to store difference between two timestamps as a number????
965816Oct 3 2012 — edited Oct 3 2012Hi
I've to find difference between 2 timestamp variables and the result should be stored as number in minutes??
like
declare
fir_timestamp timestamp(7):='01-jan-2012 13:30:00';
sec_timestamp timestamp(7):='01-jan-2012 14:00:00';
c number;
begin
c:=((sec_timestamp-fir_timestamp)/(24*60));
dbms_output.put_line(c);
end;