I am in the need of your help. Currently I am working on a web site development which is in JSP and servlet. Actually we are using Visual Age for java for the development of the same. But I have a problem in this regard.
I am having an SQL query which runs fine in Oracle client. But its not returning any recorts when I try the same query through stmt.executeQuery() method. My query is "select dc_date from dc_dim_time_master where to_date(dc_date,'DD-MON-YY') between to_date(sysdate-2,'DD-MON-YY') and to_date(sysdate,'DD-MON-YY');" I tried the same thing in Websphere application server V4.0 also. BUt no clue. Can somebody through some light on the same. Regards Yogaraj "THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE ADDRESSEE and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are notified that any dissemination, distribution or copy of this communication is strictly Prohibited. If you have received this message by error, please notify us immediately, return the original mail to the sender and delete the message from your system." =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com