SELECT to_char(to_date('08-JAN-2014','dd/mm/yyyy'), 'Dy')"Day" ,NEXT_DAY('08-JAN-2014', 'SUN') "H-SUN" ,NEXT_DAY('08-JAN-2014', 'MON') "H-MON" FROM DUAL