just make that as explicit casting like what have you done is correct. use preparedstatement and then use setObject method.
Regards Ramesh Kesavanarayanan [EMAIL PROTECTED] Off : 8113801 ext 2333 Res : 2265360 Mob : 98412 73573 > -----Original Message----- > From: Emmanuel Eze [SMTP:[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
