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!

How to Export DateTime objects?

Johnny BlocksSep 5 2024

Hello friends.

I find the SQL Developer extension much richer than the Oracle Developer Tools for VS Code.

There is one deal breaker that I am hoping I simply need some education on.

I select a date time object without any formatting.

Results panel shows: “2023-12-28 08:38” (2023-12-28T08:38)

I export the results to CSV and data is truncated to date.

CSV file shows: “27-DEC-23”

Is it possible to use the export and preserve the timestamp?

Added on Sep 5 2024

#datetime, #exportdatetime, #sqldeveloperforvscode

10 comments

863 views