-
Michael Bestikov
- PowerBuilder
- Wednesday, 16 June 2021 12:29 PM UTC
hello friends !
i want to share with you ,
how to measure service response time or any time duration
in seconds with miliseconds using Oracle .
PB CODE:
RESTClient client
client = create RESTClient
client.SetRequestHeader ("Content-Type", "application/json")
select orascheme.systimestamp_to_char
into :ls_time_from
from dual;
li_SendReturn = client.SendPostRequest(ls_service_url, JWTRequest, ls_Responsebody)
select orascheme.systimestamp_to_char
into :ls_time_to
from dual;
select orascheme.duration_for_systimestamps ( :ls_time_from, :ls_time_to)
into :ld_duration
from dual;
st_duration.text = string(ld_duration)
------------------
ORACLE FUNCTIONS:
function systimestamp_to_char return varchar2 is
v_timestamp varchar2(50);
begin
SELECT to_char(systimestamp, 'YYYY-MM-DD HH24:MI:SS.FF3')
INTO v_timestamp
FROM DUAL;
return v_timestamp;
end;
function duration_for_systimestamps(in_time_from varchar2,
in_time_to varchar2) return number is
v_duration number(5, 3);
begin
begin
select extract(second from diff) seconds
into v_duration
from (select to_timestamp(in_time_to, 'YYYY-MM-DD HH24:MI:SS.FF3') -
to_timestamp(in_time_from, 'YYYY-MM-DD HH24:MI:SS.FF3') diff
from dual);
exception
when others then
null;
end;
return v_duration;
end;
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.