sql date formatting problem

I'm trying to insert a date/time into table. I read in a date/time string from a log file, convert to date and attemt to insert, using prepared statement. I cant get format "30/09/2004 4:19:58 PM" to appear in table, only date. I have tried using Timestamp, but then i still am unable to insert. I have a deadline for today with this issue. I appreciate any help

Well, as Bear indicated, saying your problem is urgent is not likely to get you a better or faster response. Most people who can help will do so anyway whether it is urgent or not.

But anyway, one thing I spot is that you are using Oracle to_date function in your SQL, this function takes two 'Strings' as arguments, the 2nd one the date format you are using, and the 1st one a String representing the date in the format specified by the 2nd argument.

So, instead of

pstmt.setTimestamp(1, sql_date);

You want to use pstmt.setString(1, sql_date_string) where sql_date_string is a String representing date in 'dd/Mon/yyyy:hh24:mi:ss' format.

Another option would be to use a java.sql.Timestamp in a statement like "INSERT INTO EventLog (EVENT_DATE,EVENT_URL,DOWNLOAD_SIZE) VALUES (?,?,?)" , without the call to Oracle to_date function.