Insert current date time to Oracle

[Nidheesh Krishna]

Hello,
I am trying to insert current date& time to Oracle database with format "yyyy-mm-dd hh:mm:ss".
My database datatype is "DATE".

PreparedStatement statement = con.prepareStatement(query);
Date date = new java.util.Date();
long t = date.getTime();
statement.setDate(1, new java.sql.Date(t));
statement.executeUpdate();

[Nidheesh Krishna]

Nidheesh Krishna wrote:Hello,
I am trying to insert current date& time to Oracle database with format "yyyy-mm-dd hh:mm:ss".
My database datatype is "DATE".

PreparedStatement statement = con.prepareStatement(query);
Date date = new java.util.Date();
long t = date.getTime();
statement.setDate(1, new java.sql.Date(t));
statement.executeUpdate();

This is the code i used.
But in database the value stored in the format "yyyy-mm-dd 00:00:00". I want time also. How can i solve this?

[Sunil Sunny]

java.sql.Date will only provide you the date not the timestamp. So please modify your code line to

statement.setDate(1, new java.sql.Timestamp(t));