-
I'm using this SQL and QueryCommand to group by a DateTime field but using the Date portion: SELECT Count(0) as myCount, CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, myDateTimeField))) as myDateTimeField FROM myTable WHERE myOtherField = 1 ... GROUP BY CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, myDateTimeField...
-
I'm using SqlQuery and the below syntax (field and table names changed) Table with 4 columns: myGuidField, myDateField, myNumberField, myStringField SqlQuery qry = new Select( Aggregate.Avg(myTable.Columns.myNumberField), Aggregate.GroupBy(myTable.Columns.myStringField)) .From(myTable.Schema) .Where...