How do you invoke a database function call from grails?

Question

How do you invoke database functions from grails? Such as the CONVERT(decimal, timestamp) Without using groovy SQL like this:

def sql = new Sql(dataSource)

I would like to avoid any SQL statements and take full advantage of the grails magic.

Answer 1

My understanding is that grails does not have native support for database functions. You will need to write SQL. Gorm is an abstraction of Hibernate, you may want to refer to:

How can you call custom database functions with Hibernate?