Click here to Skip to main content
15,868,151 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Hello all,

I am getting a problem in my application.
I am importing data from a text file into a database table.
One of my field is of DateTime datatype.
Now, problem is dates are written in German language in that text file, for e.g.: 31-Mar-10 is written as 31-Mrz-10 and 1-May-10 is written as 1-Mai-10.
While importing, it is giving me error as "String is not a valid DateTime format".

Can anyone tell me how can i convert these german datatime strings to DateTime format.

Thanks,
Nagendra.
Posted

1 solution

You can use Convert[^] to change the datatype. Have a look at the "Date and time styles" in the documentation.

Another option is to make the reformat and conversion in C# and use DateTime.Parse[^]
 
Share this answer
 
Comments
nagendrathecoder 23-Mar-11 8:41am    
Thanks Mika, i solved it using DateTime.Parse :)
Wendelius 23-Mar-11 8:53am    
You're welcome :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900