inserting date in oracle database

Hi,
following is the java code for parsing date
------------------------------------
import java.text.SimpleDateFormat;

String dd = "2006-10-20T1350"

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-m-d'T'HHmm");
Date now = new Date();

sdf.parse( dd );
------------------------------------
iam getting following outptut
Fri Jan 20 13:50:00 GMT+05:30 2006

now i want to insert this date in oracle database column (mark as date)
pls help

Where you stuck with?

Did you write a query to insert it? Are you dealing with the current date?

Quote:

---

Originally Posted by jackjosh_in

iam getting following outptut
Fri Jan 20 13:50:00 GMT+05:30 2006

---

Where does that result come from? I get:

Code:

---

Fri Oct 20 13:50:00 CEST 2006

---

I suppose you have to fix that first.

kind regards,

Jos

ps. I'm not talking about the time zone differences; look at the month ...

In formatting I can see that, T1350. Is that formatted in correct way?

Quote:

---

Originally Posted by Eranga

In formatting I can see that, T1350. Is that formatted in correct way?

---

Note the quoted capital 'T' in the format String so yes it has the correct formatting.

kind regards,

Jos

Ok then with the testing.

It just print the 2006-10-20T1350 on the console. So?

Quote:

---

Originally Posted by Eranga

Ok then with the testing.

It just print the 2006-10-20T1350 on the console. So?

---

Try this:

Code:

---

String dd = "2006-10-20T1350";

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd'T'HHmm");

Date d= sdf.parse( dd );

System.out.println(d);

---

it definitely doesn't print 'Jan' (as the OP showed) but 'Oct' in the date output on my laptop.

kind regards,

Jos