select abs( sysdate-a) + (b-sysdate)) from table_name;[TEST@orcl] SQL>select abs((sysdate-to_date('2011-09-09','yyyy-mm-dd'))+ 2 (to_date('2011-09-09 12:12:12','yyyy-mm-dd hh24:mi:ss')-sysdate)) from dual;ABS((SYSDATE-TO_DATE('2011-09-09','YYYY-MM-DD'))+(TO_DATE('2011-09-0912:12:12',' -------------------------------------------------------------------------------- .508472222
select to_date('2011-09-09','yyyy-MM-dd')-trunc(to_date('2011-09-09 12:12:12','yyyy-MM-dd hh:ss:mi')) from dualThe following example truncates a date:SELECT TRUNC(TO_DATE('27-OCT-92','DD-MON-YY'), 'YEAR') "New Year" FROM DUAL;
select abs( sysdate-a) + (b-sysdate)) from table_name;[TEST@orcl] SQL>select abs((sysdate-to_date('2011-09-09','yyyy-mm-dd'))+
2 (to_date('2011-09-09 12:12:12','yyyy-mm-dd hh24:mi:ss')-sysdate)) from dual;ABS((SYSDATE-TO_DATE('2011-09-09','YYYY-MM-DD'))+(TO_DATE('2011-09-0912:12:12','
--------------------------------------------------------------------------------
.508472222
select to_date('2011-09-09','yyyy-MM-dd')-trunc(to_date('2011-09-09 12:12:12','yyyy-MM-dd hh:ss:mi'))
from dualThe following example truncates a date:SELECT TRUNC(TO_DATE('27-OCT-92','DD-MON-YY'), 'YEAR')
"New Year" FROM DUAL;
New Year
---------
01-JAN-92