LPAD and date format

[nir_s]

Hey all,

I've alreadt solved my problem.
The select statement should be:

select trunc(END_DATE - START_DATE)||' Days,'||
lpad((trunc((END_DATE - START_DATE)*24)-trunc(END_DATE - START_DATE)*24),2,'0')||':'||
lpad((trunc((END_DATE - START_DATE)*24*60) - (trunc((END_DATE - START_DATE)*24)*60)),2,'0')||':'||
lpad((trunc((END_DATE - START_DATE)*24*60*60) - (trunc((END_DATE - START_DATE)*24*60))*60),2,'0') AS "Gap"
from nir_test;

Regards,
Nir