Hi manishvad,
You need to make your Sql column datatype as VARCHAR(10) to insert in dd/MM/yyyy format.
If your data type is DATE or DATETIME then it only accepts MM/dd/yyyy format.
If you are trying to insert dd/MM/yyyy format from front end you will get the error as Conversion failed when converting date and/or time from character string.
So change accordingly.