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 a string using 
`to_char(crt_ts, 'yyyy-mm-dd hh24:mi:ss')
in your SELECT statement.



Christopher M. Logan schrieb am 23.02.2023 um 16:28:
> 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 oracle.sql.TIMESTAMPTZ in the grid of
>> results instead of the value. Is there a JDBC parameter or NetBeans
>> setting to not just display a string for each field for the value?
>> Thank you,
>> -Christopher
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
>> For additional commands, e-mail: users-h...@netbeans.apache.org
>>
>> For further information about the NetBeans mailing lists, visit:
>> https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
> For additional commands, e-mail: users-h...@netbeans.apache.org
>
> For further information about the NetBeans mailing lists, visit:
> https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
For additional commands, e-mail: users-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

Reply via email to