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,