SQL> select hiredate , next_day(hiredate,'SATURDAY') from emp where ename='SMITH';
HIREDATE NEXT_DAY(
--------- ---------
17-DEC-80 20-DEC-80
i want to know the exact day when smith hired,how to get this, from above query i am getting first SATURDAY of his joining,