How to round value in Criteria API

Question

Is it possible to round value in criteria api

For example I have double value a = 4.43444;

I want to make it 4.4 in criteria api.

this value goes from the calculating:

cb.quot(cb.sum(
                cb.avg(toBigDecimalProductReviewRating(cb, joinProductReview)),
                cb.avg(joinProductDefaultRating.get(ProductDefaultRating_.DEFAULT_AVG_RATING))), 2)

Answer 1

For PostgreSQL:

cb.function("round", Number.class, expression);

works well.

For 2 decimal digits:

cb.function("round", Number.class, expression, 2);