How to upload from oracle 11g to exel file?

Question

Oracle

Colleagues, how can I upload data from oracle db to exel, but so that later exel understands that there are dates in front of it?
Where can I find information about other features?

Answer 1

Any database manager (PL/SQL developer, SQL developer, DataGrip, etc.) can save query results in xls or csv, some can even upload the entire database. Run the query and look for the export button.
As for dates, it all depends on the format in which the date is stored in the database. If DATE, then most likely it will not be necessary to do anything. If in text or in TIMESTAMP, then you will have to convert with the CONVERT, CAST, TO_DATE or other suitable functions.
If you give more input (what database manager do you use, examples of data), I can specify :)