Hi
I have date + Time format set to dd/mm/yyyy and hh:nn:ss in the Options.
When I execute the SQL in Toad, the result show the correct format as per the setting BUT it will always surpress the time protion (display only Date) if the time portion is 00:00:00.
Is this the case in Toad to always surpress displaying 00:00:00 even I have set to display on certain format? Or how can i get that work ?
MANY THANKS