select extract( day from diff ) days,
extract( hour from diff ) hours,
extract( minute from diff ) minutes,
extract( second from diff ) seconds
from (select TO_TIMESTAMP('06-APR-2015 11.56.11.000000 AM','DD.MM.YYYY HH.MI.SS.FF AM') - TO_TIMESTAMP('06-APR-2014 11.56.11.000000 AM', 'DD.MM.YYYY HH.MI.SS.FF AM') diff
from dual)
SELECT *
FROM service
JOIN shopping_service
ON service.serviceid = shopping_service.serviceid
JOIN provided_service
ON provided_service.shoppingserviceid = shopping_service.shoppingserviceid
JOIN provide_service_detail
ON provide_service_detail.providedserviceid = provided_service.providedserviceid