inserting date into database using jdbc

[Bhasker Reddy]

PreparedStatement stmt_utl = dbconn.prepareStatement("INSERT INTO UTL_PROD_HISTORY VALUES (?,?,?,?,?)");
stmt_utl.setInt(1, y);
stmt_utl.setDate(2,"SYSDATE");
stmt_utl.setString(3, userid_uc);
stmt_utl.setString(4, proc_name);
stmt_utl.setInt(5, num);

stmt_utl.executeUpdate();
I am having problems inserting date into the database, how
do i retreive the date from the system.
My database is oracle, i am working on java servlets using jdbc
can anyone suggest me something

[Daniel Dunleavy]

first off, you can make the date field have a default value of sysdate
Dan

[Mike Curwen]

How about this?

PreparedStatement stmt_utl = dbconn.prepareStatement("INSERT INTO UTL_PROD_HISTORY VALUES (?,?,?,?,?)");
stmt_utl.setInt(1, y);
stmt_utl.setDate(2, new java.sql.Date(System.currentTimeMillis()));
stmt_utl.setString(3, userid_uc);
stmt_utl.setString(4, proc_name);
stmt_utl.setInt(5, num);
stmt_utl.executeUpdate();