My Java application is JDBC driver to connect to Oracle 11. I have a Date column and noticing that Oracle 11 does not store the millisecond part of the date. So when I read the Date back and look for the time in millseconds, the last thread digits are always 000.
Is this just a limit for Oracle or is there anyway to change it?
...fractional_seconds_precision optionally specifies the number of digits Oracle stores in the fractional part of the SECOND datetime field. When you create a column of this datatype, the value can be a number in the range 0 to 9. The default is 6.