<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi Jürgen,</p>
<p>Thanks for your reply.</p>
<p>I know that it works well on PostgreSQL - but I am talking about symbology rules in QGIS. Can I use Postgis syntax in QGIS rules? The QGIS query builder doesn't list "BETWEEN" as an operator.</p>
<p>Andreas</p>
<p>On 2015-11-17 18:17, Jürgen E. Fischer wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">Hi Andreas,<br /><br /> On Tue, 17. Nov 2015 at 17:01:31 +0100, Neumann, Andreas wrote:
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><br /> hm - I found out that my query <br /><br /> start_time <= now() AND end_time >= now()</blockquote>
<br /> I'd do: now() BETWEEN start_time AND end_time<br /><br /><br />
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">works fine if start_time, now() and end_time are on three different<br /> dates, but it fails if all are on the same day. Very strange. Anyone<br /> knows what's wrong?</blockquote>
<br /><br /> Strange, as<br /><br /> select '2015-11-17 18:13:11.144695+01'::timestamp <= '2015-11-17 18:13:11.144695+01'::timestamp AND '2015-11-17 18:13:11.144695+01'::timestamp >= '2015-11-17 18:13:11.144695+01'::timestamp;<br /><br /> produces "t" here on<br /><br /> version<br /> ----------------------------------------------------------------------------------------------<br /> PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit<br /><br /><br /><br /> Jürgen</div>
<br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<br /> Qgis-user mailing list<br /><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br /> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br /> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</blockquote>
<p> </p>
<div> </div>
</body></html>