title: Is it possible to insert a literal character in a TO_CHAR(datetime) format?
body: <p>I'd like to select some dates in the format:</p>
  
  <pre><code>yyyydDOY
  </code></pre>
  
  <p>where <code>yyyy</code> is the 4-digit year, <code>DOY</code> is the day of year (1-366), and <code>d</code> is a literal "d".  Here's what I tried:</p>
  
  <pre><code>SQL&gt; select to_char(sysdate, 'YYYYdDDD') from dual;
  
  TO_CHAR(
  --------
  20130713
  </code></pre>
  
  <p>Obviously that's all wrong.  The result I want can be found on the command line:</p>
  
  <pre><code>$ date +'%Yd%j'
  2013d071
  </code></pre>