Was anyone able to insert date AND time into Oracle when using SqlUpdate (a class that extends it)? In my Object arguments, I've tried to pass in both a java.util.Date and a java.sql.Date object to the update function - both results in a successful insert in the database for the DATE but the TIME portion is "missing"...
Say, my argument in the Object is
If I query the record using to_char(mydate, 'YYYY-MM-DD HH:MI:SS') after the insert, Oracle shows 2005-06-08 12:00:00 - so the date is correct but the time is not what I expected.
Any input will be much appreciated.