When i am running a query which returns results that have dates i cannot see the full date. I can see only the date and not the time and only in a specific format. I tried to change the date format under View | Toad Options | Data Grid | Data |Date format. More specifically, i always see the date in this format: dd-MM-yy regardless of what format i set it too and i can never see the time which i need to. Other people from my team can see the date and time. Not sure if this is a problem with toad version and windows version combination. Please advice how can i fix this problem.
The Toad option View | Toad Options | Data Grid | Data | Date format only apply to the Data grid not the script output.
Please use execute SQL Statement (F9) to see the date in the format desire.