In my DB, there is 5000 date values are stored like "DD-MM-YYYY" Format in nvarchar datatype. For Example 18-10-2010
And when i convert into date format for the following purpose.
"Select * from tbl_master order by Convert(datetime,date_of_Appln,103)"
Its not working.
Can you help me to convert? or Can you help me to replace the "-" symbol to "/"?
Thanks in advance.
View Complete Post