title: SQL time and date formatting against dual table
body: <p>I am trying to only display the date and time of a table in a certain format. This format is DD-MON-YYYY and the time HH24:MI:SS. I don't understand how to make both formats work together. I can get them to function separately.</p>
  
  <pre><code>select to_char(sysdate, 'DD-MON-YYYY', systimestamp,'HH24:MI:SS') from dual;
  </code></pre>
  
  <p>My error is 'too many arguments'. I want to understand why it isn't working.</p>