I have one table that has an alarm generation date in the format MM-DD-YYYY HH:MM:SS AM and a Call start field in another table with the format YYYY-MM-DD HH:MM:SS. I've used the very basic query below to get the raw information. How do I get the difference between the two fields as they are in different formats?
select p.alarm_generation_dt, o.call_start
from phm_interaction_pers p, phm_outbound o
where o.call_start like '2014-12-03%'