how to insert current date and time to db using sql

Question

hi,

I used the following code, but the DateTime field at sql is 2005-04-08 00:00:00

I want to have the time too. where should i change

... ...

// Get the system date and time.
java.util.Date utilDate = new Date();
// Convert it to java.sql.Date
java.sql.Date date = new java.sql.Date(utilDate.getTime());
...
...
...
PreparedStatement stmt = connection.prepareStatement(sql);
stmt.setDate(1, date);

Answer 1

Try using setDate(utilDate) instead of trying to set SQL date. In SQL, date and time are different data types.

Answer 2

Try using setTimestamp instead of setDate, since a timestamp is the prefered format for data and time.

Answer 3

Try this:

Connection con;
Statement stmt;
con = DriverManager.getConnection(url, username, password);
stmt = con.createStatement();
stmt.executeUpdate("INSERT INTO MYTABLE(time) " +
"VALUES ('" + new java.sql.Date(System.CurrentTimeMillis())"');");

Answer 4

Use the sql function now().

INSERT INTO table date_field VALUES(NOW());