Toad World® Forums

trunc function with dates


I am using Toad for Data Analysts 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


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.