I have a table with date column and has a value say, 2006-02-12 10:12:34. iam using MySQL 5.0

Now I have to take only the 10:12 from the above column and match a set of rows in another table which has a column of type Date.
How Do I do it using hibernate? I use HQL basically for retrieval of data.


My Query is something like this.
"List l =getHibernateTemplate().find(" FROM PatientFlowSheetData p where HOUR(p.flowSheetColumnTime) ='10' and MINUTE(p.flowSheetColumnTime) ='12'")" --- This works. :-)

But this is strictly linked with MySQL. I don't want that. Does hibernate have any functions similar to this.

Please reply if I'm not making you understand. I'll try to rephrase.
:-)

Pretty much everything available to you in HQL is listed in section 14.9, "Expressions", of the ref docs. hour() and minute() are provided.

Wow!! Yes.. How did I miss that?
Just Overlooked it.
Thanks a lot. :-)