Setting date to oracle using Prepared Statement

[Vasudevan Gopalan]

Hi,
I am setting date to oracle using prepared statement.I am using the following code

java.util.Date dt = new java.util.Date();
pst.setDate(5,new java.sql.Date(dt.getTime()));

In database it is setting date alone but not the hour,minute and sec.I need to set the date with hour,minute & sec.

Regards
Vasu
[ February 29, 2004: Message edited by: Vasudevan Gopalan ]

[Bikramjit Singh Bajwa]

Pass following method in your java.sql.Date constructure
System.currentTimeMillis()
Hope this works
Chakk de
Bikram

[Bikramjit Singh Bajwa]

Sorry to tell you one thing more..
may be your database field would be Date type only instead of DateTime or timestamp..
Chakk de
Bikram

[Dirk Schreckmann]

Moving this to the JDBC forum...

[Christopher Zinn]

java.sql.Date will only fill out the date portion;
java.sql.Timestamp will fill in both portions

  java.util.Date dt = new java.util.Date();
  pst.setTimestamp(5,new java.sql.Timestamp(dt.getTime()));
  or
  pst.setTimestamp(5,new java.sql.Timestamp(System.currentTimeMillis());

- Chris

[Vasudevan Gopalan]

Thanks Christopher...