I finally loaded the session log which is in CSV format into a database table called TAB1
How do you subtract timestamps or dates?
SELECT timestamp FROM TAB1 WHERE MESSAGE_CODE = 'WRT_8006' minus
SELECT timestamp FROM TAB1 WHERE message_code = 'WRT_8147'
SELECT timestamp FROM TAB1 WHERE MESSAGE_CODE = 'WRT_8006' :--> 8/6/2012 12:35
SELECT timestamp FROM TAB1 WHERE message_code = 'WRT_8147'----->8/6/2012 7:34
i would expect 8/6/2012 12:35 minus 8/6/2012 7:34 ...around 5 hrs
but i am unable to do
this timestamp is stored as VARCHAR2 datatype in TAB1
so any inputs of how to do to_DATE (timestamp) and do subtraction
or tell me if any-other method to calculate the timestamp difference so i can figure out how long it writer thread took pl;ace