title: Invalid Input syntax for type interval postgres
body: <p>I have a Sql code which should pull the active data from the table by using an interval function.</p>
  
  <pre><code>Select * from contacts
  Where systemmodstamp::date &gt; (current_date - interval '${p_active_data_days_interval} day')::date
  </code></pre>
  
  <p>The <code>p_active_data_days_interval</code> is used as a parameter and the declared value is set to "30" in setting tab. systemmodstamp is a field of type timestamp without time zone.</p>
  
  <p>When previewing the data resulting an error: </p>
  
  <blockquote>
    <p>invalid input syntax for type interval: "${p_active_data_days_interval} day"</p>
  </blockquote>