title: Formatting a date in SQL
body: <p>I am trying to write a query that shows the newest book with a date format of <code>"January 3, 2011"</code> but I keep getting errors when trying to format the date. </p>
  
  <p>Below is the working query without the date formatted:</p>
  
  <pre><code>SELECT title, pubdate 
  FROM   books
  WHERE  pubdate =
         ( SELECT MAX(pubdate)
           FROM   books );
  </code></pre>