Hi Yon,
format() function comes in help on this. Try this:
*select record_date.format('YYYY') as mo, record_date.format('MM') as da
from V group by da, mo*
Lvc@
On 8 April 2015 at 17:02, yon fey <[email protected]> wrote:
> how do I group by month on a date property in orientdb something similar
> to the below
>
> GROUP BY YEAR(record_date), MONTH(record_date)
>
>
> thanks
>
> --
>
> ---
> 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.
>
--
---
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.
