title: Oracle SQL Create Date from Parts
body: <p>I have two date fields in a database called "EFFECTIVE_DATE" and "POINT_DATE" </p>
  
  <p>How do I create a new date field, where the date is made up from the year of "EFFECTIVE_DATE", the month of "POINT_DATE"  and the day of "POINT_DATE" ?</p>
  
  <p>I would normally use Datefromparts, but this is an Oracle Database not Microsoft </p>
  
  <p>Kind Regards</p>