I think it's a problem in the Oracle JDBC driver.
Most likely NetBeans uses the toString() method to display the column values.
But oracle.sql.TIMESTAMPTZ does not implement toString() and thus it's this
typical Java "toString()" representation.
I think the only workaround is to retrieve it as
Hi Sean,
That's what I think is going on behind the scenes for a database
result-set. My screenshot is from the built-in NetBeans screen showing
the results of a SQL query. I'm using the Oracle JDBC driver to connect
to Oracle 19c database, Running a SQL query and getting results. The
grid is
Christopher,
What is the code you are using to display the values? From the
screenshot you provided, it looks like you just passed an object and its
/toString()/ method is being used to display it.
-SC
On 2/23/23 9:28 AM, Christopher M. Logan wrote:
Here is a screenshot showing the issue.
Here is a screenshot showing the issue.
Thank you
-Christopher
---
On 2023-02-23 07:45, Christopher M. Logan wrote:
I'm using NetBeans v14 to connect to Oracle database using JDBC driver
ojdbc10.jar - connecting to Oracle 19c database. But when resultsets
contain a timestamp I see
I'm using NetBeans v14 to connect to Oracle database using JDBC driver
ojdbc10.jar - connecting to Oracle 19c database. But when resultsets
contain a timestamp I see oracle.sql.TIMESTAMPTZ in the grid of results
instead of the value. Is there a JDBC parameter or NetBeans setting to
not just
