HI i am running the below script but would like to sum up the amount of seconds for each day to shorten the results:
script is:
SELECT NOP_ID||','||FRN_ID||','||IN_PRODUCT||','||OUT_PRODUCT||','||CALL_START_DATE||','||DURATION_IN_SECONDS||','||ERROR_VALUE FROM ERROR_CDR
where fk_bar_run_number...
HI i am running the below script but would like to sum up the amount of seconds for each day to shorten the results:
script is:
SELECT NOP_ID||','||FRN_ID||','||IN_PRODUCT||','||OUT_PRODUCT||','||CALL_START_DATE||','||DURATION_IN_SECONDS||','||ERROR_VALUE FROM ERROR_CDR
where fk_bar_run_number...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.