Duration between 2 dates

[nread]

Hi

could someone help me with trying to determine the duration in seconds between 2 dates...?

This is what i'm trying to do :

select
START,
RELEASE,
(TO_DATE(
SUBSTR(RELEASE, 1, length(RELEASE) - 4), 'YYYY-MM-DD HH24:MI:SS'))-
(TO_DATE(
SUBSTR(START, 1, length(START) - 4), 'YYYY-MM-DD HH24:MI:SS')) As Duration
from table 1

Thanks everyone...

 

[carp]

Assuming start and release are already dates, I would take the difference between them (giving me the duration in days), and multiply the results by 86400 (24*60*60) to get seconds.

It would look something like:

SELECT (release - start) * 86400 "Seconds"
FROM table_1;

 

[carp]

Since it appears that your columns are NOT date datatypes, I would use something like the following:

SELECT (to_date(releace,'YYYY-MM-DD HH24:MI:SS') - to_date(start,'YYYY-MM-DD HH24:MI:SS')) * 86400 "Seconds" 
FROM table1;