title: Date in mmm yyyy format in postgresql
body: <p>I have a table with a column of type timestamp without time zone.</p>
  
  <p>I want to select that column with the <code>mmm yyyy</code> format – for example, “Mar 2011”.  How to format it that way?  I tried:</p>
  
  <pre><code>select cast(now() as date)
  </code></pre>
  
  <p>but it is giving me the incorrect format.</p>