I need to "Export Dataset" from the "Data Grid" tab of Schema Browser but I'm getting inconsistent formats for the dates.
To test, I have a simple one date column table... in sqlplus
SQL> select col1 from pj.pjdates;
The data grid (and the exported csv) however, shows:
I want to use the data as a source for sqlloader, so a consistent format is required.
Is there a way to always show/export the time portion, even if it's a trunc'd date?
(I know I can use TO_CHAR() but I want to use this data extraction technique for a large number of tables with a large number of DATE datatype columns so wanted an easier fix )
Toad for Oracle version 220.127.116.11
View > Options > Data Grids > Data : Date format = dd/mm/yyyy
View > Options > Data Grids > Data : Time format = hh:mm:ss