How to insert/update Date field in Oracle with java code

[sasi.tati]

:confused:Dear All

I have to insert/update a date column while creating a new item, but the problem is i am able to insert/update only date but i need both date and time along with AM/PM.

By using these 3 lines i am able to insert/update only date.
java.util.Date date = new java.util.Date();
long dateLong = date.getTime();
stmtPrep.setDate(33, new java.sql.Date(dateLong));

Below code retrives the date exactly what i need but unable to pass in the statement:
DateFormat formatter = new SimpleDateFormat("dd-MM-yyyy HH:mm:ss a");
java.util.Date d = (Date) new java.util.Date();
String stringdate = formatter.format(d);
String tmpdate = dateFormat();
stmtPrep.setString(33, tmpdate); -- I tried with setObject as well but same error coming.

Error is:
ORA-01830: date format picture ends before converting entire input string

Can u guide me how to get full date time with AM/PM?

[doWhile]

While the information about your db and code is lacking, I will ask why you need more than the the first date update...am/pm is already stored in the original Date object you used to call setDate, it just needs to be formatted when retrieved.

[RamyaSivakanth]

have u tried with setTimeStamp method?