Can u get the object as
Object o = resultset.getObject(n);
and manipulate it later.
--- Dan Lopez <[EMAIL PROTECTED]> wrote:
> I am trying to query a simpledatetime field in my
> db.
> I have a problem with Date type in JSP code. I
> import
> java.sql.* and Date and Time work fine. However
> when
> I try to import java.util.* and
> java.text.SimpleDateFormat for formating date, time
> and locale, I get error since java.sql.* and
> java.util.* both import Date.
>
> I can do something like this for date formating
> alone
> and it works for me with util and SimpleDateFormat:
> <%
> SimpleDateFormat datef, timef;
> Date tim = new Date();
> Locale fi = new Locale("fi", "FI");
> datef = new SimpleDateFormat("MM-dd-yyyy", fi);
> timef = new SimpleDateFormat("HH:mm:ss", fi);
> %>
> Display formatted date only:<%= datef.format(tim) %>
>
> But here I display query resultset with java.sql.*
> in
> which I can do Date or Time and not both:
> <%
> if (myResultSet != null) {
> while (myResultSet.next()) {
> Date x = myResultSet.getDate(n);
> ...
> or
> Time x = myResultSet.getTime(n);
> ...
>
> 1.How do I display both time and date?
> 2.How do I format date?
> 3.How is date arithmetic done in JSP? on DB side or
> in
> JSP code?
>
> **Note I display as**
>
> <table>
> <tr>
> <td><%= x %>
> </tr>
> </table>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> 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
__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
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
