Dateformatting from Custom Format

set as first command in your query:
set language German
(see here[^] and here[^])
In that case you will be able to convert your datetime

http://blog.sqlauthority.com/2008/08/14/sql-server-get-date-time-in-any-format-udf-user-defined-functions/[^]
Just try this Link...!
Regards..!
Dnyanesh

First off, always convert dates from strings to DateTime values as soon as possible, and preferably on the machine on which the user typed them - that way there is a good chance that the Culture format matches the way the user has entered them. Or better still, use a DateTimePicker so it is presented in a culture-dependant way and =given to you as a DateTime directly. And try to avoid passing date strings to SQL - you generally have no idea what culture it is working in, so unless you reformat them to ISO standard (yyyy-MM-dd) there will probably be problems later. Pass the DateTime value directly as a parameter, and SQL will understand it regardless of it's source.

If you have to parse a date from a string, and you know exactly what format the date will be in, use DateTime.ParseExact

DateTime dt = DateTime.ParseExact("09.Mar.12", "dd.MMM.yy", CultureInfo.InvariantCulture);

Do not insert the datetime value as a string! Use a parameterized query, it will handle the date time correctly, not depending from your locale settings.
When you use a string, you will run into problems. Some of our customers in Germany use English server systems, and then the SQL server runs on the server (with US-English Windows settings), while the client computers run on German XP or Win7...