Insert date on Oracle

[kha0s]

how can I update a dateTime on a Oracle DATE column?

I tryed a lot of different methods, including embedding SQL92 syntax, but I can never seem to do it.

How should I do through JDBC?

 

[JeffShelley]

did you try this?

"update table set date = to_date(?, 'YYYY-MM-DD-HH.MI.SS.000000')"

then do ...

Statement.setTimestamp(your Timestamp object);
Statement.executeUpdate();