How to run variable in Netezza?
<p>I am trying to run some code in Aginity for Netezza without putting it in a stored procedure, but I can't get the syntax right. Here is some sample code below.</p>

<pre><code>\set STARTDATE '2016-01-19 00:00:00';
\set ENDDATE '2016-01-19 23:59:59';
select * from LOG where create_time between :STARTDATE and :ENDDATE;
</code></pre>

<p>and the error is this:</p>

<blockquote>
  <p>error ^ found ":" (at char 60) expecting an identifier found a keyword </p>
</blockquote>