Hi,
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!
Banner:
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
"CORE 11.2.0.2.0 Production"
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production