I have two tables. Cla_case cc and Cla_event ce. The join between the two tables is on cc.cla_event_no = ce.cla_event_no.
In cla_case i have the following columns : Discover_date and Notification_date. In cla_event I have the column Incident_date.
I need to perform a SUBQUERY that will find the latest date (most recent) when comparing cc.Discover_date and ce.Incident_date. Once it has done this I then need to subtract this record from cc.Notification_date to find out how many DAYS occurred until the incident was reported.
My date format is as follows : 16-APR-2008 07.50
Once again I only require the DAYS between Notification and the latest date between Discover and Incident.
Thank-you very much!
Oracle Database 11g Release 22.214.171.124.0 - 64bit Production
PL/SQL Release 126.96.36.199.0 - Production
"CORE 188.8.131.52.0 Production"
TNS for Linux: Version 184.108.40.206.0 - Production
NLSRTL Version 220.127.116.11.0 - Production