title: DATEDIFF command won't work as 'day' is not a recognised column
body: <p>I'm relatively new to SQL and have been attempting to run a script wherein I can bring up the number of days that have passed between two points in time. I understand how this should look based on your website, but for some reason when I input the values, my database is returning the following error:</p>
  
  <p>ProgrammingError: ERROR:  column "day" does not exist</p>
  
  <p>The code I'm using is:</p>
  
  <pre><code>select datediff(day, '2014-01-01', '2014-02-01')
  </code></pre>
  
  <p>I assume I'm missing something very simple (this is a hugely basic query I'm sure), but would be appreciative of any assistance. I've variously tried pointing it towards the specific table I want to draw from, but it keeps stumbling on this error.</p>