I have a column in oracle in time stamp format, it has a value like this 05-MAY-17 11.01.17.939951000 AM. when my java code picks that roe and when I do a ResultSet.getString("coulmn name"), I am getting value like this 2017-05-05 11:01:17.939. is there a way I can get full value for that field.
Asked
Active
Viewed 63 times
0
-
Why are you using getString to get a timestamp? – Alex Poole May 17 '17 at 22:03
-
I did ResultSet.getTimestamp() as well. got the same result @AlexPoole – Ranjith Reddy May 17 '17 at 22:16
-
Your talking about getting 100th of microseconds? Perhaps the JDBC driver conversion of date has lost precision. Have you tried reading using timestamp? – Minh Kieu May 17 '17 at 22:45
1 Answers
0
How to print time up to 6 digits of precision for seconds value
The last answer on the page shows a solution that goes up to 9 values for the seconds. This might help you.
Community
- 1
- 1
Jenny Holder
- 63
- 1
- 11