[Qgis-user] Issue with temporal query in a symbology rule
Jürgen E. Fischer
jef at norbit.de
Tue Nov 17 09:17:53 PST 2015
Hi Andreas,
On Tue, 17. Nov 2015 at 17:01:31 +0100, Neumann, Andreas wrote:
>
> hm - I found out that my query
>
> start_time <= now() AND end_time >= now()
I'd do: now() BETWEEN start_time AND end_time
> works fine if start_time, now() and end_time are on three different
> dates, but it fails if all are on the same day. Very strange. Anyone
> knows what's wrong?
Strange, as
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;
produces "t" here on
version
----------------------------------------------------------------------------------------------
PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit
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/470abf65/attachment.sig>
More information about the Qgis-user
mailing list