['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."]