PreparedStatement ps = conn.prepareStatement("insert into tablename
(datecol, others) values (?,
othervalue)");
ps.setDate(1, birthday);
ps.execute();----- Original Message ----- From: "Emmanuel Eze" <[EMAIL PROTECTED]> To: "JDJList" <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 11:37 AM Subject: [jdjlist] Re: sql Date > Thanks! It worked. But again, how do I insert this date into the table? > > I wish to use "insert into tablename (datecol, others) values (datevalue, > othervalue)" > > -----Original Message----- > From: zlatko [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 07, 2002 11:24 AM > To: JDJList > Subject: [jdjlist] Re: sql Date > > > I think you can use the second constructor: > > Calendar cbirthday = null; > java.sql.Date birthday = null; > cbirthday = Calendar.getInstance(); > cbirthday.set(Integer.parseInt(year), Integer.parseInt(month), > Integer.parseInt(day)); > birthday = new java.sql.Date(cbirthday.getTime().getTime()); > > ----- Original Message ----- > From: "Emmanuel Eze" <[EMAIL PROTECTED]> > To: "JDJList" <[EMAIL PROTECTED]> > Sent: Tuesday, May 07, 2002 11:20 AM > Subject: [jdjlist] Re: sql Date > > > > java.sql.Date has just 2 constructors: > > Date(int year, int month, int day) > > Deprecated. instead use the constructor Date(long date) > > Date(long date) > > Constructs a Date object using a milliseconds time value. > > > > None of them seem to satisfy java.sql.Date sqlDate = new > > java.sql.Date(birthday.getTime()); > > > > Emma > > > > -----Original Message----- > > From: zlatko [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 07, 2002 11:04 AM > > To: JDJList > > Subject: [jdjlist] Re: sql Date > > > > > > You have to create new java.sql.Date instance to do it : > > > > java.sql.Date sqlDate = new java.sql.Date(birthday.getTime()); > > > > and to pass it as parameter of the setDate(java.sql.Date) method > > > > ----- Original Message ----- > > From: "Emmanuel Eze" <[EMAIL PROTECTED]> > > To: "JDJList" <[EMAIL PROTECTED]> > > Sent: Tuesday, May 07, 2002 11:03 AM > > Subject: [jdjlist] 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 interger 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 folllowing 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 chnage it to: > > > birthday = (java.sql.Date) cbirthday.getTime(); > > > > > > Pls tell me what I'm doing wrongly. > > > > > > Emma > > > > > > > > > To change your membership options, refer to: > > > http://www.sys-con.com/java/list.cfm > > > > > > > > > To change your membership options, refer to: > > http://www.sys-con.com/java/list.cfm > > > > > > To change your membership options, refer to: > > http://www.sys-con.com/java/list.cfm > > > > > To change your membership options, refer to: > http://www.sys-con.com/java/list.cfm > > > To change your membership options, refer to: > http://www.sys-con.com/java/list.cfm > To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
