In my previous version of Toad (9.0), I was able export query results into a tab delimited text file and date formatted fields would return as such: MM/DD/YYY.
In Toad for Data Analyst date fields return like this: MM/DD/YYYY hh:mm:ss.
I’ve looked everywhere. I’ve tried truncating the date, to no avail.
I’ve tried to_char, which works, but then the data type is varchar2.
I have a feeling I’m missing something simple and obvious.