View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3821816#3821816
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3821816 Probably this may work out for you... with some amout of extra coding. The EJB QL for the finder would be SELECT OBJECT(o) from myBean as o where SUBSTRING(o.startdate,0,9) = ?1 startdate is a date field in the database and the finder method will take string as the parameter. This string parameter should be the date that you want to check from the database. The default format for the date field from the database also matters in this approach. So the finder definition would be Collection findCustomersOnDate(java.lang.String date) //date ="16-FEB-04" The finder will return a collection and when you print the date field, you can always get the full date(ie untruncated) cheers.... ------------------------------------------------------- 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
