CODE EXAMPLE FOR SQL

oracle INTERVAL DAY to second to number

SELECT extract(DAY FROM (ts1 - ts2) * 86400) FROM dual;