Use trunc in select query with group by clause - Oracle on March 21, 2008 mysql +0 oracle mysql oracle