Re: Oracle insert date and time

I have a JDBC current date and time insert into Oracle 9i that almost
works. It submits the current date and a fixed time into the Oracle
date type field. I am using Tomcat 6.0.20.
For example if I insert the data at 7:24:04 PM on Feb 16, 2010 it will
insert as: 16-Feb-2010 12:00:00 AM
The date part works but the time always shows 12:00:00 AM no matter
what date or time the data is inserted.

Here is what I have for my JDBC inserts and I also tried something
with DateFormat:
PreparedStatement ps;
Date mydate = new Date(new java.util.Date().getTime());
//insert statement here....

stmt.setDate(1,mydate);

I also tried:
PreparedStatement ps;
java.sql.Timestamp mydate = new java.sql.Timestamp(new
java.util.Date().getTime());
SimpleDateFormat fmt = new SimpleDateFormat(....
//insert statement here....
ps.setTimestamp(1,fmt.format(mydate));

Both keep submitting the date into Oracle as 16-Feb-2010 12:00:00 AM
Anyway to get the current date and time? For example if I insert the
data at 7:24.04 pm today it should show as 16-Feb-2010 07:24.04 PM in
Oracle.