Thursday, November 29, 2007

calculate time between to columns

SELECT TO_DATE( '27-NOV-07 15:35:44', 'DD-MON-YY HH24:MI:SS' )
- TO_DATE( '27-NOV-07 15:02:50', 'DD-MON-YY HH24:MI:SS' ) days
, TO_CHAR( TRUNC( sysdate )
+ ( TO_DATE( '27-NOV-07 15:35:44', 'DD-MON-YY HH24:MI:SS' )
- TO_DATE( '27-NOV-07 15:02:50', 'DD-MON-YY HH24:MI:SS' )
)
, 'MI:SS' ) minsec
FROM dual;
DAYS MINSE
---------- -----
.022847222 32:54

No comments: