date and time in sql

[kirupa shankari]

How to get the current system time and date and store it in Ms- Access database using java.sql package?

[Thomas Paul]

java.util.Date d = new java.util.Date();
java.sql.Date date = new java.sql.Date(d.getTime());
preparedStatement.setDate(colNum, date);