SQL Column Date Type insertion problem

[Ravi Kiran Va]

Hi ,

I always face problem when inserting Date into a Date Type column Type .

Assume ,that i have a table like this as shown below :

DESC trans_master

Name Type
TXN_ID VARCHAR2(10)
IN_TIME DATE

when i tried to work with the below code , it gave a sqlexception saying that , Invalid month .

String str_date="11-11-2005"; 
String sql = "insert into trans_master(TXN_ID, IN_TIME)VALUES ('Test', str_date)";

I also tried with using SimpleDateFormat , in which it also gave a error .

String str_date="11-11-2005";   
DateFormat formatter = new SimpleDateFormat("dd/mm/yyyy");   
Date date  = (Date)formatter.parse(str_date);   
String sql = "insert into swe.trans_master(TXN_ID, IN_TIME)VALUES ('Test', date)";
int a  = stmt.executeUpdate(sql);

Exception in thread "main" java.text.ParseException: Unparseable date: "11-11-2005"
at java.text.DateFormat.parse(Unknown Source)

So please tell me , how can i insert a date in SQL Oracle Database having a Date Column .

Thanks .

[Christophe Verré]

Use a PreparedStatement and setDate(int, Date) instead of hard coding the values.

[Ravi Kiran Va]

Use a PreparedStatement

hey , this is only for testing a standalone program .
Hey leave about the PreparedStatement right now , i am right now interested to work with Statement only , how is it possible to insert a Date into SQL Column of Date Type .

Thanks.

[Christophe Verré]

Why wouldn't you use a PreparedStatement even to test a standalone program ?

Oh well... You can try this instead :

insert into trans_master(TXN_ID, IN_TIME)VALUES ('Test', TO_DATE('20051111', 'YYYYMMDD'))

Hey

Doesn't sound very nice...

[Ravi Kiran Va]

insert into trans_master(TXN_ID, IN_TIME)VALUES ('Test', TO_DATE('20051111', 'YYYYMMDD'))  

you were being deviated from the actual question . doesn't need this .

Doesn't sound very nice...

Are you using any Talking buddies to hear these characters .

[Jaikiran Pai]

Ravi Kiran Va wrote:

insert into trans_master(TXN_ID, IN_TIME)VALUES ('Test', TO_DATE('20051111', 'YYYYMMDD'))  

you were being deviated from the actual question . doesn't need this .

No one was deviating from the question. The reply is appropriate for the question you asked.

Ravi Kiran Va wrote:

Doesn't sound very nice...

Are you using any Talking buddies to hear these characters .

You are crossing the Be Nice rule and that won't be tolerated. If you want help for your questions, please make sure that you don't repeat this attitude again.