I use Oracle db; in a table I have a DATE type field (myDate).
I don't have problem with O/R mapping but I need to implement, with Criteria, something that generates a query similar:

select TO_CHAR(myDate,'YYYY/MM/DD HH24'), count(*) from myTable
group by TO_CHAR(myDate,'YYYY/MM/DD HH24')


Do you have an idea about the solution with Criteria and Projection for this problem?


Thank you very much

Stefano

Just a hint: look at Projections.sqlGroupProjection
I'd a quick look at the source and I think it can do wath you want, but I've never tried it.

Thank you very much Marco,
the sqlGroupProjection works correctly

Projections.sqlGroupProjection("to_char(myDate,'YYYY/MM/DD HH24') as myDate, count(*) as myCount", "to_char(myDate,'YYYY/MM/DD HH24')",
new String[]{"myDate", "myCount"" }, new Type[]{new StringType(), new ShortType() } ));

With Eclipse debug it wasn't so difficult to find the right syntax.

I'm from Imola, I didn't think that my problem's solution came so near to me.

Stefano

Hey Stefano, I'm glad I've helped, especially a 'romagnolo' ! ;)
Please, don't forget to rate !