Question: how to change date format in toad for oracle?
Answer: Nimish, ...  In toad go to format change, the format as dd-mm-rrrr. ...  Do the following steps to change the date format in TOAD. ...  Go to View->Options->Data Grids->Data. ...  Go to View->Options->Data Grids->Data. ...  This is now in tools grids, but it is a useful tip. ...  SELECT TO_CHAR(MYDATE,'DD-MM-RRRR') FROM TABLE NAME.