Hi all,
I have a set of records and I would like to group them by day using a
DATETIME field.
In SQL, 'GROUP BY' uses results of the SELECT and applies a "GROUP BY" at
this moment:
SELECT date(date_field) as d, COUNT(*) FROM my_table GROUP BY d;
OrientDB seems to don't apply the 'GROUP BY' on results:
SELECT date_field.format('yyyy-MM-dd') as d, COUNT(*) FROM my_table GROUP
BY d;
This Query returns nothing because d is not in same format as date_field.
Any idea?
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.
