trunc function with dates

rickr48 · October 28, 2009, 4:20pm

I am using Toad for Data Analysts 2.5.0.913 that came with my Toad for Oracle v10 … problem: select trunc(sysdate) from dual; (or any date from any table) … the results are like this … 10/28/2009 12:00:00 AM …
In regular Toad the same command with this result … 10/28/2009 … THIS IS WHAT I WANT … is there a setting or something that needs to be set ???

Thanks … Rick

Debbie_Peabody · October 28, 2009, 4:30pm

If you go to the Grid display options you can choose to only show date. You don't have to use the trunc fuction. See screenshot. To access the option window use the Tools Menu. It is at the bottom.

Debbie