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