It looks like you don't want to compare dates in Java at all.
You're comparing dates in SQL
How you should do that depends on your DBMS.
what's wrong with the example code you gave?
Maybe try: FinishedDate between date1 and date2
Geert 'Darling' Van Damme
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Virendra Wathare
> Sent: dinsdag 2 mei 2000 14:19
> To: [EMAIL PROTECTED]
> Subject: Date Comparison!!!
>
>
> Hi guys,
>
> I have a problem. I want to compare dates in java i.e.
> specifically I want to compare 2 date values falling
> between a particular range. For e.g.
>
> "Select date1,date2 from table1 where FinishedDate >=
> date1 and FinishedDate <= date2 ";
>
> Please could somebody help me regarding the syntax and
> the exact comparison operator to be used.
>
> Thanx in advance,
>
> Virendra.
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
>
> ==================================================================
> =========
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
