SQL> select empno,to_char(hiredate,'yyyy-mm-dd HH24-MI-SS') from scott.emp where empno in (7369,7499);
EMPNO TO_CHAR(HIREDATE,'YYYY-MM-DDHH
----- ------------------------------
7369 1980-12-17 00-00-00
7499 1981-02-20 00-02-02
SQL>
SQL> select trunc(
2 ((select hiredate from scott.emp where empno=7499)-
3 (select hiredate from scott.emp where empno=7369)-
4 trunc(
5 (select hiredate from scott.emp where empno=7499)-
6 (select hiredate from scott.emp where empno=7369)))*24*60) from dual
7 ;
TRUNC(((SELECTHIREDATEFROMSCOT
------------------------------
2