[Qgis-user] Issue with temporal query in a symbology rule

[Jürgen E. Fischer]

Hi Andreas,

On Tue, 17. Nov 2015 at 19:24:20 +0100, Neumann, Andreas wrote:
> 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. 

Oh, I completely missed that you were talking about an expression. Sorry.

But I cannot reproduce the problem with an expression either:

  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')

produces 1 too.


Jürgen

-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden             http://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode                         
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 827 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151117/94a112e2/attachment.sig>