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

Reply via email to