How do I get Day of the Month with this methdology:
like x.getDay() or x.getMonth()
is there a way (I know there should be...) to
x.getDayOfMonth()
--- Magesh CS <[EMAIL PROTECTED]> wrote:
> 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
__________________________________________________
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
