title: convert sql server AlphaToDate4 to oracle date which has 5 numbers
body: <p>Hi good day I have the following code I am trying to convert from sql server to oracle, It works perfectly on sql but not on oracle. How can I convert the ff?</p>
  
  <p>This is the code from sql</p>
  
  <pre><code>Select CONVERT(VARCHAR, RLL.dbo.AlphaToDate4(A.DATE_R), 103) CaptureDate
  from Employees
  </code></pre>
  
  <p>This is the format of Date_R (78684)</p>
  
  <p>I am trying to write the following code in oracle but gives me an error</p>
  
  <pre><code>select TO_DATE((A.DATE_R),'DD/MM/YYYY')  CAPTUREDATE
  </code></pre>