Grails: createCriteria query, group by day, on a single date field (modify for grouping by month, year, hour, minute, seconds)

Grails: createCriteria query, group by day, on a single date field

DOMAIN CLASS (Post):
String timeDay
Date date
static mapping = {
    timeDay formula: "FORMATDATETIME(date, 'yyyy-MM-dd')" // h2 sql
    //timeMonth formula: "DATE_FORMAT(time, '%Y-%m-%d')"   // mysql sql
}

CONTROLLER:
def c = Post.createCriteria()
def charting = c.list {
    eq("project", project)
    between("date", fromDate.getTime(), toDate.getTime()) 
    projections {
        groupProperty('timeDay')
        count('date')
    }
    order("timeDay", "asc")
}