title: Oracle SQL TRUNC command shows year as 0022 instead of 2022
body: <p>I have some basic SQL coding</p>
  <pre><code>select
  job.job_number,
  job.actual_comp_date,
  TO_CHAR(TRUNC(TO_DATE(job.actual_comp_date,'DD/MM/YYYY')),'DD/MM/YYYY') as Truncated_Date
  
  from
  job
  </code></pre>
  <p>What I am expecting to see is</p>
  <p><code>job number      actual_comp_date         truncated_date</code></p>
  <p><code>1234            01/04/2022 23:23:23      01/04/2022</code></p>
  <p><code>1234            01/04/2022 23:23:23      01/04/2022</code></p>
  <p><code>3837            23/04/2022 13:23:23      23/04/2022</code></p>
  <p>Instead what I am seeing is the year changed to 0022 as below:</p>
  <p><code>job number      actual_comp_date         truncated_date</code></p>
  <p><code>1234            01/04/2022 23:23:23      01/04/0022</code></p>
  <p><code>1234            01/04/2022 23:23:23      01/04/0022</code></p>
  <p><code>3837            23/04/2022 13:23:23      23/04/0022</code></p>
  <p>How do I change the code so that it shows the year correctly?  Basically I want to strip the time out of actual_comp_date.</p>