I have a columns timestamp where I save the the datetime in this 'yyyy-MM-dd'T'HH:mm:ss.SSS'-0700' format.
It looks like this: ----+-----+----------+---------------------------- # |@RID |sysdate |timestamp ----+-----+----------+---------------------------- 0 |#-2:1|19-04-2015|2015-03-28T00:20:27.027-0700 1 |#-2:6|19-04-2015|2015-03-29T00:20:27.027-0700 ----+-----+----------+---------------------------- Now I want to group records by just this format: 'yyyy-MM-dd', just the date, and not the time. I checked online for solution to it, and people recommended GROUP BY CAST(d. log_date AS DATE). Orientdb doesn't support CAST, I guess. How should I go about it then? Any help or suggestions are appreciated. -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.