D
ddog
I'm trying to write a java.sql.Date to a database and the minutes/
seconds etc. are not being written. I've seen and tested many examples
found via searches and still have come up with nothing. Here's what I
have:
java.sql.Date formation - recommended forms:
java.sql.Date entryDttm = new
java.sql.Date(System.currentTimeMillis());
OR
java.sql.Date entryDttm = new java.sql.Date(new
java.util.Date().getTime());
// prepared statement insert
pstmt.setDate(1, entryDttm);
// what is written to database
2007-02-07 12:00:00.000
// what needs to be written
2007-02-08 09:37:25.793
The field is stored in a MS SQL Server 8.0 database and is defined as
a 'datatime' field. Using JDK 1.5.
What do I need to do to have the minutes/seconds/milliseconds written?
seconds etc. are not being written. I've seen and tested many examples
found via searches and still have come up with nothing. Here's what I
have:
java.sql.Date formation - recommended forms:
java.sql.Date entryDttm = new
java.sql.Date(System.currentTimeMillis());
OR
java.sql.Date entryDttm = new java.sql.Date(new
java.util.Date().getTime());
// prepared statement insert
pstmt.setDate(1, entryDttm);
// what is written to database
2007-02-07 12:00:00.000
// what needs to be written
2007-02-08 09:37:25.793
The field is stored in a MS SQL Server 8.0 database and is defined as
a 'datatime' field. Using JDK 1.5.
What do I need to do to have the minutes/seconds/milliseconds written?