Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
isnt working for me. i thought this is how it's supposed to be used. but i'm getting ORA-01858 a non-numeric character was found where a numeric was expected
select NEXT_DAY(to_char(to_date(20131003,'yyyymmdd'), 'MON-DD-YY'),'Tuesday') from dual;