I send the registration date parameter to mysql database like "22-12-2010". But my sql date date type is within another formate how do i alter the date formate like "2010-12-22" also i must place this into table.

Give code in c#,asp.internet code behind either sql query statement!


Make use of this comprehensive MSDN pages as the guide: Standard Date and Time Format Strings and Custom Date and Time Format Strings.

You will find many good examples on individuals pages regarding how to reformat to start dating ? string in C#, and in addition they give a good obvious explanation how date formatting works within the DateTime class.

Once you have reformatted your date string in C#, you need to have the ability to transfer lower without requiring to make use of SQL to reformat it.