Structure is '2015-12-06 00:00:00
Actually this query is work when from date is '2016-9-29' and to date up to
'2016-12-31'
select dob, anniversary_date from (select expand(out('store_customer'))
from #48:843) where is_deleted = 0 and in_store_customer['out =
#48:843'].is_active = 1 and dob.format('MM-dd') between '09-29' to '12-31'
desc skip 0 limit 11
but if my to date changes to next year ie to '2017-01-31' that query is
not working
select dob, anniversary_date from (select expand(out('store_customer'))
from #48:843) where is_deleted = 0 and in_store_customer['out =
#48:843'].is_active = 1 and dob.format('MM-dd') between '09-29' to '01-31'
desc skip 0 limit 11
--
---
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.
