Hi, did you try the date() function ( http://orientdb.com/docs/last/SQL-Functions.html#date)?
Regards Le lundi 20 avril 2015 07:55:20 UTC+2, Kishy Kumar a écrit : > > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
