title: How to format a Date variable in PLSQL
body: <p>I am new to PL/SQL and have this question.</p>
  
  <p>I created a procedure with the following specification:</p>
  
  <pre><code>PROCEDURE runschedule (i_RunDate  IN DATE)
  </code></pre>
  
  <p>this <code>i_RunDate</code> comes in a specific format, and I need to change it to this format:</p>
  
  <pre><code>'MM/dd/yyyy hh:mi:ss PM'
  </code></pre>
  
  <p>I couldn't find how to re-format a Date variable.</p>