OraFAQ Forum: JDeveloper, Java & XML » pls help!! for inserting date in oracle database.

Home » Developer & Programmer » JDeveloper, Java & XML » pls help!! for inserting date in oracle database.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pls help!! for inserting date in oracle database. [message #457379]

Mon, 24 May 2010 02:49

jackjosh_in
Messages: 2
Registered: May 2010
Location: mumbai

Junior Member

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

String dd = "2006-10-20T1350"

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

sdf.parse( dd );
------------------------------------
iam getting following outptut

Fri Oct 20 13:50:00 GMT+05:30 2006

How to insert above date in oracle database. pls help iam new

Report message to a moderator

Re: pls help!! for inserting date in oracle database. [message #457400 is a reply to message #457379]

Mon, 24 May 2010 04:31

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

insert into mytable (mydatecolumn) values (to_date(?,'YYYY-MM-DD"T"HH24MI'));

And then bind "dd".

Regards
Michel

[Edit: Add code tags)

[Updated on: Mon, 24 May 2010 06:16]

Report message to a moderator

Re: pls help!! for inserting date in oracle database. [message #457406 is a reply to message #457400]

Mon, 24 May 2010 05:43

jackjosh_in
Messages: 2
Registered: May 2010
Location: mumbai

Junior Member

Thank u very much Smile

Report message to a moderator

Previous Topic:	XML parsing
Next Topic:	SetPrompt function of SortableHeader is not displaying the column header

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 01 05:34:58 CDT 2023