To all: I am trying to do a comparison for a date field. My EJB QL is: select object(c) from tableschema as c where start_date between ?1 and ?2
The dates are: 01/05/2005 00:00AM and 01/05/2005 11:59 PM. I am trying to find all data that have a start_date of 1/05/2005. My program is using a dynamic query so I need to pass the parameters. Before, I passed java.sql.Date but I can not specify the hours and minutes for java.sql.Date. Is there a way to do this? Thank you. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3865054#3865054 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3865054 ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
