5 Replies Latest reply on Oct 9, 2014 7:21 AM by Arpod

    Issues with to_date and to_char functions

    1007989

      to_date and to_char not working properly.

       

        
         select TO_DATE (TO_CHAR (TO_DATE (SYSDATE - 1, 'DD-Mon-YY'), 'DD-Mon-yy'),
                    'DD-Mon-YY'
                   ) from dual;