Posted by Roberto Nenni on 07/11/05 19:28

hi all and sorry for my english

I write into a SqlServer2000 database via jdbc using a PreparedStatement
(pstmt) and one of fields is a TimeStamp, my code is:
qwdum=System.currentTimeMillis();
pstmt.setTimestamp(8 , new Timestamp(qwdum));

sometimes the field on table is correct (the milliseconds are the same of
last 3 digits of variable qwdum), other times it has a difference of 1 o 2
milliseconds

the same code with jdbc Oracle or iSeries works fine

any idea?

thanks

Roberto Nenni

[Back to original message]