Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Incorrect QueryResult output for date

Lukas OraJan 27 2025

Hello everyone,
Due to an error on my part, the date “13.01.0061” was saved in the database in a date column (format: DD.MM.YYYY) . Instead of the actual date "13.01.1961".
In a QueryResult of the VS Code SQL Developer Extention, however, the date "13.01.1961" was output.
The year was displayed incorrectly by the Extention in the QueryResult. This made troubleshooting drastically more difficult. Using Desktop SQL Developer, I then found out that the year “0061” was actually stored in the database instead of the displayed “1961”. The QueryResult in the Desktop SQL Developer was "13.01.0061".
Could this incorrect behavior of the Extention be adapted to that of the Desktop SQL Developer?

Many thanks for your efforts
Best regards

Comments
Post Details
Added on Jan 27 2025
11 comments
176 views