Hi Kishy,
I must have been asleep while trying to help you. Let's try this again.
I'm assuming your timestamp property is a String. If so, use this:
select timestamp.asDate().format("YYYY-MM-dd") as dt from FILE order by dt
If you need to make it part of a group by then do something like this:
select someproperty, timestamp.asDate().format("YYYY-MM-dd") as dt from
FILE group by someproperty, dt
Let me know if that helps.
-Colin
On Wednesday, April 22, 2015 at 1:35:24 AM UTC-5, Kishy Kumar wrote:
>
> Still the same....
>
> orientdb {db=baasbox}> select timestamp.format("'yyyy-MM-dd'") as dt from
> FILE group by dt
> 0 item(s) found. Query executed in 0.02 sec(s).
>
> One thing that I don't understand is that how will the following just
> group by date and not by time:
> ** .format("'yyyy-MM-dd'T'HH:mm:ss.SSS'Z")
>
>
>
--
---
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.
