I tried the query, its working for some values and it is giving error for others.
It is converting '7/12/1430' into gregorian.
where as it is giving error for '30/12/1430'.
I am using the below query for conversion.
Select Convert(Datetime,'30/12/1430',131) and i get an error
Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.