Can you share your test DB ore describe your databases's schema, please?
What version are you using?
Il giorno giovedì 29 settembre 2016 15:25:13 UTC+2, Pugazharasan Thirumalai
ha scritto:
>
> 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.
