title: Formatting DATE in oracle
body: <p>I have a date field in a table that contains date in dd-MMM-yy  format .</p>
  
  <p>I want to create a function that get this date check it for not null and then change it to yyyy/mm/dd format</p>
  
  <p>but the problem is that oracle doesn't accept dd-MMM-yy formate date as a input parameter and
  it say : Please Use yyyy-MM-dd date format !!!</p>
  
  <p>how can I first change dd-MMM-yy formate to  yyyy-MM-dd so oracle accept it as input then change it to yyyy/mm/dd</p>