title: How to generate date in SQL Query?
body: <p>I want to generate date value since 1/1/2011 - 31/12/2011 on sql query.</p>
  
  <p>Example 
  My Table A</p>
  
  <pre><code>Field A     Field B       Field C
     1       01/01/2011      125
     2       03/01/2011      100
     3       05/01/2011       50 
  </code></pre>
  
  <p>I want to result :</p>
  
  <pre><code>Field A     Field B       Field C
     1       01/01/2011      125
     0       02/01/2011        0
     2       03/01/2011      100
     0       04/01/2011        0
     3       05/01/2011       50 
     ...
     0       31/12/2011       0 
  </code></pre>
  
  <p>Please Advice Me and Thank a lot.</p>