title: Convert 24 Hour time to 12 Hour plus AM/PM indication Oracle SQL
body: <p>I am required to do the following as an exercise, and I am struggling to find a solution:</p>
  
  <p>Write a SELECT statement that returns these columns from the Invoices table:</p>
  
  <p>The invoice_date column</p>
  
  <p>Use the TO_CHAR function to return the invoice_date column with its full date and time including a four-digit year on a 24-hour clock</p>
  
  <p>Use the TO_CHAR function to return the invoice_date column with its full date and time including a four-digit year on <strong>a 12-hour clock with an am/pm indicator</strong>.</p>
  
  <p>Use the CAST function to return the invoice_date column as VARCHAR2(10)</p>
  
  <p>All I can get is:</p>
  
  <pre><code>    select invoice_date, to_char(invoice_date, 'DD-MM-YYYY HH:MM:SS') "Date 24Hr"
      from invoices
  </code></pre>
  
  <p>Which gets my first two columns, however I can't figure out any way to select the third column.
  Any help would be great, thanks. (And yes, this is from my school textbook)</p>