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.

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

84 views