3 Replies Latest reply: Jan 22, 2014 9:47 AM by Efren.R-Oracle RSS

    How to capture ORA-01850 hour must be between 0 and 23

    Efren.R-Oracle

      Hello,

       

      The Date Picker allow to enter manually in the textfield any value.  well if a user enter 24:00 for the hour the application fails. I would like to handle the error.  I have a validation entry, but of course the to_date conversion is failing with the above,  EXTRACT function also fails......any ideas?

       

      Thanks,

      Efren