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
Thursday, November 29, 2007
Subscribe to:
Posts (Atom)