title: Date format in Informix
body: <p>Is it possible to print the <code>date</code> in the below format in <code>Informix DB</code>,</p>
  
  <p><code>May 19 1993 12:00AM</code> ?</p>
  
  <p>Consider the below eg.,</p>
  
  <p>If I shoot the below query,</p>
  
  <pre><code>select sysdate from systables;
  </code></pre>
  
  <p>It displays as,</p>
  
  <pre><code>2017-12-15 05:00:47.24318
  </code></pre>
  
  <p>But I want the output to be printed as,</p>
  
  <pre><code>Dec 15 2017 05:00AM
  </code></pre>