orientdb {compleanni}> select from V

----+-----+-------------------
#   |@RID |dob                
----+-----+-------------------
0   |#9:9 |2016-03-29 00:00:00
1   |#9:10|2016-10-29 00:00:00
2   |#9:11|2016-11-29 00:00:00
3   |#9:12|2016-12-29 00:00:00
4   |#9:13|2016-01-29 00:00:00
----+-----+-------------------


orientdb {compleanni}> select * from v where dob.format('yyyy-MM-dd') 
between '2016-09-29' and '2017-01-31'

----+-----+-------------------
#   |@RID |dob                
----+-----+-------------------
0   |#9:10|2016-10-29 00:00:00
1   |#9:11|2016-11-29 00:00:00
2   |#9:12|2016-12-29 00:00:00
----+-----+-------------------

3 item(s) found. Query executed in 0.003 sec(s).


Using 1.7 version.

Though that's a really old version, I suggest you to update to the latest 
2.2.10


Il giorno giovedì 29 settembre 2016 16:11:06 UTC+2, Pugazharasan Thirumalai 
ha scritto:
>
> Am using version: orientdb-community-1.7.11-20141127.163804-2-distribution
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to