6 Replies Latest reply on Mar 24, 2005 5:14 AM by orawarebyte

    Date Nvl Function

    orawarebyte
      Hi,

      I have a form having date local variable

      Declare

      Mdate_From Date;

      Begin

      message(TO_CHAR(nvl(MDATE_FROM,' '),'YYYYMMDD'));

      End;

      Why this statment of code give error

      ORA-01847 day of month must be between 1 and last day of month

      When I dont use nvl function it works fine.

      Thanx in Advance