This content has been marked as final. Show 5 replies
(TIMESTAMPDIFF(SQL_TSI_MINUTE, "batch_job_execution.end_time", "batch_job_execution.start_time")*24*60) / (write_count)
Appreciate if you mark as correct
For issues let me know
if need use SQL_TSI_SECOND for seconds instead of minutes as SQL_TSI_MINUTE
Edited by: Srini VEERAVALLI on Jan 8, 2013 5:24 PM
Thank you for the quick response.
I will not be able to try this until tomorrow when I have access to the system.
At first glance I am questioning whether the TIMESTAMPDIFF function will carry over the timestamp
output format to the end result?
The end state result I am seeking will have to be an INTEGER reflecting (Records Per Second - 999999999)
Let me know your thoughts.
TIMESTAMPDIFF function returns number type. I hope you are good with that.
Let me know updates.
I attempted to use the TIMESTAMPDIFF function and I am receiving error ORA-00904 invalid identifier.
I do not find this function in my Oracle SQL book so I'm assuming this might be a function that was created internally
within your enterprise. Please correct me if I am wrong. This may have to be the path I take. (Create a FUNCTION to perform TIMESTAMPDIFF processing)
Again, this is just some of my thoughts based on my research and I could be far off.
Please advise or confirm my suspicions.
You suppose to use given expression in OBIEE Answers->Criteria-> Column expression.
If you are not using BI and trying to execute in sqlplus then make sure you use TO_DATE function if reqired
Edited by: Srini VEERAVALLI on Jan 9, 2013 1:07 PM