C# string to SqlDateTime: how to set format for recognition?

c# asp.net datetime locale sqldatetime
Askar Ibragimov picture Askar Ibragimov · May 29, 2013 · Viewed 7.7k times · Source

I need to use 

SqlDateTime.Parse(val)

where val is a string such as " 23.3.1992 00:00:00 ".

The string is in European format, that is, day precedes month. However Parse wants "American" format. How I can tell it to use particular datetime format / locale?

Thanks in advance!

Answer

Khadim Ali picture Khadim Ali · May 29, 2013

Try this:

string val = "23.12.1992 00:00:00";

// Parse exactly from your input string to the native date format.
DateTime dt = DateTime.ParseExact(val, "dd.M.yyyy hh:mm:ss", null);

// Part to SqlDateTime then            
System.Data.SqlTypes.SqlDateTime dtSql = System.Data.SqlTypes.SqlDateTime.Parse(dt.ToString("yyyy/MM/dd"));

This could be done in one statement, but just separated for illustration.

Related questions

DateTime.TryParse issue with dates of yyyy-dd-MM format

I have the following date in string format "2011-29-01 12:00 am" . Now I am trying to convert that to datetime format with the following code: DateTime.TryParse(dateTime, out dt); But I am alwayws getting dt as {1/1/0001 12:00:00 AM} , Can you …

Read More
How do I loop through a date range?

I'm not even sure how to do this without using some horrible for loop/counter type solution. Here's the problem: I'm given two dates, a start date and an end date and on a specified interval I need to take …

Read More
Check if datetime instance falls in between other two datetime objects

I would like to know a simple algorithm to check if the given instance of datetime lies between another two instances in C#. Note: I skimmed though this How do I check if a given datetime object is "between" two …

Read More