CODEWITHSUNDEEP
orientdborientdb2.2
Joe Taras
Joe Taras

Reputation: 15379

OrientDB error on query date

I've this table with these fields:

MyTable
code STRING
fromDate DATE
toDate DATE

The content of this table is the 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 I try to write this query:

SELECT FROM MyTable WHERE fromDate <= '2016-05-01'

or alternatively

SELECT FROM MyTable WHERE fromDate <= DATE('2016-05-01', 'yyyy-MM-dd')

The result is the 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 the row with equal condition on date. Where's my fault?

Orient version I've used is 2.2.0

Upvotes: 0

Views: 67

Answers (1)

Joe Taras
Joe Taras

Reputation: 15379

From OrientDB team the notice is arrive this bug has closed and will be released on 2.2.5 version

Go here

Upvotes: 1

Related Questions