Beginner |
|
Joined: Wed Jan 25, 2006 10:16 am Posts: 44 Location: Bangalore
|
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.
:-)
_________________ Please vote if my Postings helps. :-)
|
|