Posted on: 7/8/2012 1:11:02 AM | Views : 267

Hi All
I am stuck we are in a maintenance team of a ASP Code and the C# Front end Code sends the date in dd/mm/yyyy But the Sql Server datetime format is set to mm/dd/yyyy Now our client wants to fix the bug without changing any Code in Front end C# he wants us to alter the procedure in SQL Server So that while inserting date from front end it is converted in Backend SQL server to mm/dd/yyyy I have tried to convert it using convert function and style set to 101 but still it doesnt work ... Kindly help me out how can I accept date in dd/mm/yyyy from front end and while inserting in table I can Convert it to mm/dd/yyyy ....Thanks in Advance
rajdey1
...

Go to the complete details ...