The Oracle stored procedure of SQL statement execution time how accurate to ms-CodePudding

, strives for the bosses to help busy,

CodePudding user response:

To get precise millisecond directly use "TimeStamp" type variables:
Declare
Cur_time timestamp;
The begin
Cur_time:=current_timestamp;
Dbms_output. Put_line (to_char (cur_time));
end;

CodePudding user response:

Quote: reference 1/f, freedom and responsibility response:

Cur_time:=current_timestamp;
Current_timestamp what do you mean??
CodePudding user response:
Computing two timestamps are the number of milliseconds apart, but do you have any question on the second floor, don't know timestamp is what meaning, that is to say,

Select the extract (day from intv) * 24 * 60 * 60 * 1000
+ extract (hour from intv) * 60 * 60 * 1000
+ extract (minute from intv) * 60 * 1000
* 1000 + extract (second from intv)
The from (SELECT SYSTIMESTAMP - timestamp '2019-10-12 15:52:00 AS intv from dual);
CodePudding user response:
I want in the storage process of SQL execution time accurate to milliseconds how can I express???????
CodePudding user response:
I have given you explain very clearly, you don't know, how can I express?
CodePudding user response:
Milliseconds need calculated using timestamp type,