title: Change a SQL server query to equivalent in SQLite
body: <p>I have this query which works in SQL server: </p>
  
  <pre><code>Convert(datetime, [ChangedDate]) &gt;= DATEADD(DAY, -3, CAST(GETDATE() AS DATE)) 
  </code></pre>
  
  <p>I want to make it work in Android SQLite database.</p>
  
  <p>As far as I understood I need to use something like: <code>date('now','+14 day')</code> instead of <code>DATEADD</code>, but it gives me an error on <code>datetime</code> (it could be here Convert(datetime,...) in sqlite.</p>
  
  <p>Can you modify this query in order to make it works on SQLite?</p>