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

[Neumann, Andreas]

hm - I found out that my query 

start_time <= now() AND end_time >= now() 

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? 

Andreas 

On 2015-11-17 16:51, Neumann, Andreas wrote: 

> Hi, 
> 
> For a project I have point data for events with a start_time and end_time, both columns are of type timestamp without timezone (in PostgreSQL). 
> 
> I want to have three different rules for events in the past, current events and future events. 
> 
> Past and future events work fine, but I am struggling with the query for the current events. 
> 
> I use the query 
> 
> start_time <= now() AND end_time >= now() 
> 
> But the query fails - the object aren't selected - even if I am sure that there are matching objects in my database. Is this not a valid query? Any other idea on how to test for current events? In PostgreSQL I could use intervals and test for overlaps - but this isn't available in QGIS. 
> 
> Thanks for any hints, 
> 
> Andreas 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151117/4b77b7b2/attachment.html>