grails - How to fix an hibernate criteria datepart error? -

i have domain calculated field.

durationinminutes formula: 'datepart(minute, duration) + datepart(hour, duration) * 60'

and use in createcriteria

property('durationinminutes')

but generates error in logfile

java.sql.sqlexception: 'this_.minute' not recognized datepart option.

please help. use mysql.

found working solution:

projections {     sqlprojection '(datepart(minute, duration) + datepart(hour, duration) * 60) timeinminutes', 'timeinminutes', integer

i using mysql database, think hibernate releated question?

Abdulaziz