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

Question

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!

Do you not have a DateTime instance to pass in to the database? Why use strings at all for this? — Oded
– Oded, Commented May 29, 2013 at 12:38
Why not use something totally unambigious like YYYY-MM-dd HH:mm:ss so 2013-05-29 13:38:00 then everything will know what it means. — Belogix
– Belogix, Commented May 29, 2013 at 12:38
SqlDateTime uses the InvariantCulture. When you need something different use a DateTime and its Parse overloads where you can provide a different culture or format. And then use the SqlDateTime constructor that takes a DateTime. And like the other if possible better try to use a culture independent string format if needed. — Ralf
– Ralf, Commented May 29, 2013 at 12:44

Khadim Ali · Accepted Answer · 2013-05-29 12:52:14Z

5

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.

answered May 29, 2013 at 12:52

Khadim Ali

2,5383 gold badges39 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vikram Bose · Accepted Answer · 2013-05-29 12:55:55Z

2

Have you tried DateTime instead of SQLDateTime

DateTime d = DateTime.Parse(val); 
String s = d.ToString(CultureInfo.CreateSpecificCulture("en-US"));

answered May 29, 2013 at 12:55

Vikram Bose

3,3852 gold badges20 silver badges35 bronze badges

Comments

Mehdi Bugnard · Accepted Answer · 2013-05-29 12:42:39Z

0

Can you try this ?

string valInEuropean = "23.3.1992 00:00:00";
DateTime dateInEuropean = DateTime.Parse(valInEuropean);
string valInAmerican = dateInEuropean.ToString("yyyy-MM-dd HH:mm:ww");

answered May 29, 2013 at 12:42

Mehdi Bugnard

3,9875 gold badges51 silver badges89 bronze badges

2 Comments

Chris Over a year ago

This will only work if his culture is already set to European, otherwise the DateTime.Parse call will fail.

Mehdi Bugnard Over a year ago

euhh yes, but it does or not?

Ratna · Accepted Answer · 2013-05-29 12:51:21Z

0

For converting a string to datetime object when the format is known(in this case ) use

DateTime dwweek = DateTime.ParseExact("23.3.1992 00:00:00", "dd.MM.yyyy hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture);

answered May 29, 2013 at 12:51

Ratna

2,3293 gold badges26 silver badges51 bronze badges

Collectives™ on Stack Overflow

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

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related