<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>I created two expressions:</p>
<p>startzeit <= now() AND endzeit >= now()</p>
<p>vs</p>
<p>to_datetime(format_date(startzeit,'yyyy-MM-ddTHH:mm:ss')) <= now() AND to_datetime(format_date(endzeit,'yyyy-MM-ddTHH:mm:ss')) >= now()</p>
<p>-------------</p>
<p>The first fails, the second works fine - with some unneccesary conversion from DateTime to String and then back to DateTime.</p>
<p>So there seems to be an issue with the interpretation of DateTime objects in QGIS expressions. At least for PostgreSQL data sources.</p>
<p>Andreas</p>
<p>On 2015-11-18 11:17, Neumann, Andreas wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<p>Hi Jürgen,</p>
<p>I can follow your examples - they work fine.</p>
<p>My conclusion is that the expressions are fine - but there is an issue if the attribute data that comes from Postgis with a data type "timestamp without time zone". Maybe these attribute columns from Postgis aren't correctly evaluated as a DateTime data type?</p>
<p>------------------</p>
<p> </p>
<p>I'll send you some sample data privately.</p>
<p>Thanks,</p>
<p>Andreas</p>
<p> </p>
<p>On 2015-11-17 21:29, Jürgen E. Fischer wrote:</p>
<blockquote style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0;"><!-- node type 8 --><!-- node type 8 --><!-- node type 8 -->
<div class="pre" style="margin: 0; padding: 0; font-family: monospace;">Hi Andreas,<br /><br /> On Tue, 17. Nov 2015 at 19:24:20 +0100, Neumann, Andreas wrote:
<blockquote style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0;">I know that it works well on PostgreSQL - but I am talking about<br /> symbology rules in QGIS. Can I use Postgis syntax in QGIS rules? The<br /> QGIS query builder doesn't list "BETWEEN" as an operator.</blockquote>
<br /> Oh, I completely missed that you were talking about an expression. Sorry.<br /><br /> But I cannot reproduce the problem with an expression either:<br /><br /> to_datetime('2015-11-17T21:24:18') <= to_datetime('2015-11-17T21:24:18') AND to_datetime('2015-11-17T21:24:18') >= to_datetime('2015-11-17T21:24:18')<br /><br /> produces 1 too.<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>
<!-- html ignored --><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>