Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dhenderson01
Starting Member
4 Posts |
 Posted - 2006-05-28 : 15:48:34
|
| I'm trying to assign a date to a column in a oracle table. The format of the date I'm trying to pass is 06/01/2005. I have looked at the api for DATE, but can't get it right.Could somebody help me with this problem?Here's what I have so far:sql = "insert into table1(acct_id,date1,date2) values(?,?,?)"String a = null;String d1 = "06/01/2005"; String d2 = "06/01/2006";stmt.setString(1,a);stmt.setDate(4,d1);stmt.setDate(4,d2);Don |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-28 : 18:43:17
|
| This is a forum for questions about Microsoft SQL Server. You should post your question on a site that handles questions about Oracle.http://www.dbforum.com/CODO ERGO SUM |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-29 : 01:47:09
|
| or at www.Orafaq.comMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
DATE