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
Post a Comment