Error "java.text.ParseException: Unparseable date" due to Missing Trailing ".0" in Date String Retrieved from Database Using ResultSet.getString() on a Date/Timestamp Column
Last updated on MAY 31, 2018
Applies to:JDBC - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 11.2]
Information in this document applies to any platform.
You have noticed that when you retrieve a DATE field from the database using the method ResultSet.getString(), the date string is missing the trailing ".0"
java.text.ParseException: Unparseable date: "2010-05-31 00:00:00" at java.text.DateFormat.parse(DateFormat.java:337) at JdbcVersion.selectDate(JdbcVersion.java:70) at JdbcVersion.main(JdbcVersion.java:23)
You have recently upgraded your Oracle JDBC driver to 188.8.131.52.0
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms