OQL Grouping By Dates

2
Hi there, I'm trying to group an OQL report by a date/time field, using an attribute called (OrderDate) The problem is, when I group-by the attribute in the OQL query, I get the dataset grouped by timestamp. I need to display the grouping by day. Can anyone help me figure this out in OQL? I need to round off my attribute to the nearest day, and drop the time information of the timestamp.
asked
1 answers
0

See doc DATEPART

answered