title: Split Date from Oracle Form to DB
body: <p>I have a table with columns(year,day-month) -date type- in my database.
  and a form with a text field for the user to enter a date.
  how can I split the entered date to save it on db as following</p>
  
  <pre><code>year     day_month
  ----     ---------
  2018     03-04
  </code></pre>
  
  <p>I tried <code>SUBSTR(TO_CHAR(TO_DATE(block.field))</code> in a trigger ,
  but it didn't work bcz the column type is date, and I tried to add <code>TO_DATE()</code> as outer but the result was</p>
  
  <pre><code>year           day_month
  ----------     ----------
  03-04-2018     03-04-2018
  </code></pre>
  
  <p>How can I do it without changing my columns type?</p>