hi,
for inserting a date into the database, i use the following code.
Calendar cal; // The date to be inserted
String colValue = "";
colValue =
"'"+(cal.get(Calendar.MONTH)+1)+"/"+cal.get(Calendar.DAY_OF_MONTH)+"/"+cal.g
et(Calendar.YEAR)
+" "+cal.get(Calendar.HOUR_OF_DAY) +
":"+cal.get(Calendar.MINUTE)+"'";
then..
String sql = "Insert into table(...) values ('aa'," + colValue + ")"
then use sql for inserting the record.
hth,
Nagarajan.
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Bhushan_Bhangale
> Sent: Tuesday, May 07, 2002 11:14 AM
> To: [EMAIL PROTECTED]
> Subject: Re: sql Date
>
>
> You cannot cast a java.util.Date to a java.sql.Date since the util.Date is
> the parent class of sql Date.
>
> -----Original Message-----
> From: Emmanuel Eze [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 07, 2002 1:46 PM
> To: [EMAIL PROTECTED]
> Subject: Re: sql Date
>
>
> Even if I do that, how do I then convert the java.util.Date to
> java.sql.Date?
>
>
> -----Original Message-----
> From: Bhushan_Bhangale [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 07, 2002 11:05 AM
> To: [EMAIL PROTECTED]
> Subject: Re: sql Date
>
>
> First of all:-
>
> java.util.sql birthday = null; should be java.util.Date
> birthday = null;
>
> as the Calendar.getTime() method returns a util date object.
>
> -----Original Message-----
> From: Emmanuel Eze [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 07, 2002 1:34 PM
> To: [EMAIL PROTECTED]
> Subject: sql Date
>
>
> Hi all,
>
> Can somebody pls tell me how I can insert a Date type into a
> database table
> with a Date datatype?
>
> I have the year, month, and day as integer values. I need to
> convert these
> values into an sql Date object so I can now insert the Date
> object into the
> table, right?
>
> I have the following code:
> Calendar cbirthday = null;
> java.util.sql birthday = null;
> .
> .
> .
> cbirthday = Calendar.getInstance();
> cbirthday.set(Integer.parseInt(year), Integer.parseInt(month),
> Integer.parseInt(day));
> birthday = cbirthday.getTime();
>
> This last statement throws a cast exception! Even when I change it to:
> birthday = (java.sql.Date) cbirthday.getTime();
>
> Pls tell me what I'm doing wrongly.
>
> Emma
>
> ==================================================================
> =========
> 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
>
> ==================================================================
> ========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
>
> ==================================================================
> =========
> 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
>
> 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
===========================================================================
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
