title: SQLite - Checking if time is more then one month ago
body: <p>Checking if DATETIME (TIME) is more then one month ago</p>
  
  <p>This is the Update I am trying to do:</p>
  
  <pre><code>DELETE FROM BLOCKDATA WHERE TIME &lt;= DATEADD(MONTH, -1, GETDATE());
  </code></pre>
  
  <p>But it fails with the error: </p>
  
  <pre><code>No such column: month
  </code></pre>
  
  <p>The table:</p>
  
  <pre><code>      String sql = "CREATE TABLE BLOCKDATA " +
                " (ID    INTEGER PRIMARY KEY, " + 
                " PLAYERID           TEXT    NOT NULL, " +
                " TIME           DATETIME    NOT NULL, " + 
                " LOCATION           TEXT    NOT NULL, " + 
                " ACTION            TEXT     NOT NULL, " + 
                " SPECIAL        TEXT, " + 
                " SPECIAL2         TEXT)"; 
  </code></pre>
  
  <p>I am using Java.</p>