orientdb2.2 - OrientDB error on query date -


i've table these fields:

mytable code string fromdate date todate date 

the content of table following:

'abc', '2016-05-01 00:00:00', '2016-05-31 00:00:00' 'def', '1900-01-01 00:00:00', '2099-01-01 00:00:00' 'ghi', '1900-01-01 00:00:00', '2099-01-01 00:00:00' 

if try write query:

select mytable fromdate <= '2016-05-01' 

or alternatively

select mytable fromdate <= date('2016-05-01', 'yyyy-mm-dd') 

the result following:

'def', '1900-01-01 00:00:00', '2099-01-01 00:00:00' 'ghi', '1900-01-01 00:00:00', '2099-01-01 00:00:00' 

so, orientdb doesn't return row equal condition on date. where's fault?

orient version i've used 2.2.0

from orientdb team notice arrive bug has closed , released on 2.2.5 version

go here


Comments

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

android - Robolectric "INTERNET permission is required" -

java - Android raising EPERM (Operation not permitted) when attempting to send UDP packet after network connection -