You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OMC HOW-TO: Reporting differences between dates in a log entry

Accepted answer
edited Sep 27, 2018 7:04PM in Observability & Management 10 comments


Overview of how you can use Log Analytics query language to get the difference between two time/dates stored in a single log entry.


If you have a log entry where you have parsed and store two time/date fields such as Event Start Time and Event End Time, then the query language allows you to do math manipulation on these to display the duration between these two dates. In this example, we have a log entry from Oracle E-Business Suite's FNDWFBG Workflow Background program. This log has a start and end time for a background process that have been stored into the Event Start Time and Event End Time fields respectively.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!