inserting date in oracle database

[jackjosh_in]

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

[Eranga]

Where you stuck with?

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

[JosAH]

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

Where does that result come from? I get:

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 ...

[Eranga]

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

[JosAH]

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

[Eranga]

Ok then with the testing.

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

[JosAH]

Ok then with the testing.

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

Try this:

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