View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3821707#3821707
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3821707 Hello everybody, I was wondering if u could help me out.. I have the following finder method: @ejb.finder signature = "java.util.Collection findMemberSchedule(java.lang.String memberId, java.util.Date date)" query = "select object (sch) from Schedule sch, Member mem WHERE sch MEMBER OF mem.schedules AND mem.id=?1 AND sch.departureTime =?2" when I use this method, it returns an empty collection. The reason: When I send a date to be compared with the date in the DB, it tries to match the year, month, day, hour, minute, and second... I would only like to get the record matching today's date.. so, is there any way I could do that? The date in stored in a mySQL DB and is a dateTime. Thanks in advance.. ------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
