Hi there. I'm trying to insert a date stamp into a derby db. I create a variable of type Timestamp and set it up with the current system time. This works fine because I tested the it in a dummy class.
Timestamp ts = new Timestamp(System.currentTimeMillis());
However when I insert the timestamp into the db with this code:
stmtSaveNewRecord.setTimestamp(3, ts);
The data saved in the table is 1 Jan 1970. When I saved it the data in the table as date data type it worked but Timestamp and Time are giving hassles and I need to save the time into the database.