title: Athena / Presto data last week
body: <p>I am currently trying to write an Athena query to fetch all data in a table from the last 7 days.</p>
  <pre><code>SELECT *
  FROM &quot;engagement_metrics&quot;.&quot;spikes&quot;
  where spike_noticed_moment_utc &gt; date_add('day', -7, now())
  </code></pre>
  <p>When running this query I get the following error:</p>
  <pre><code>SYNTAX_ERROR: line 3:32: '&gt;' cannot be applied to varchar, timestamp with time zone
  </code></pre>
  <p>How can I achieve grabbing data from the last week given the current day in Athena?</p>