C# DateTime Convert from String

Question

I am reading excel file in my C# .net web application and storing that value in Database. Ony of field in Excel is DateTime. I am storing it in string

string tran_time = Convert.ToString(odr[5]); //tran_time is "03-11-2012 16:08:43"

and then convert it in in DateTime and store it in Database (SQL Server 2008)

IFormatProvider culture = new CultureInfo("en-US", true);
DateTime dateVal = DateTime.ParseExact(tran_time, "dd-MM-yyyy HH:mm:ss", culture);

But the Value Being stored in Database is in format

2012-05-11 13:40:23.000 (yyyy-mm-dd)

and the value in Excel is 05-11-2012 13:40:23 (dd-mm-yyyy)

Date & Month is get replaced.

My Question is How can i store it in Database in Format (YYYY-MM-DD HH:MM:SS:FFF)

"But the Value Being stored in Database is in format [...]" - why aren't you storing it as a DateTime in the database? Then you don't have a format. — Jon Skeet
– Jon Skeet, Commented Nov 5, 2012 at 15:54

Oded · Accepted Answer · 2012-11-05 15:54:12Z

3

But the Value Being stored in Database is in format

No it isn't (assuming that you are using a DATETIME column type). This is just what the SQL tools show you.

A DateTime instance, either in a database or in C# does not have an associated format. It only gets formatted when displayed to the user.

answered Nov 5, 2012 at 15:54

Oded

501k102 gold badges900 silver badges1k bronze badges

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

Comments

Vishal Suthar · Accepted Answer · 2012-11-06 05:14:33Z

0

Or use yyyy-MM-dd format. Works like a charm:

string myString = dateVal.ToString("yyyy-MM-dd");

edited Nov 6, 2012 at 5:14

Vishal Suthar

17.2k4 gold badges64 silver badges109 bronze badges

answered Nov 5, 2012 at 16:49

Half_Baked

3404 silver badges18 bronze badges

Comments

Roy Dictus · Accepted Answer · 2012-11-05 15:54:56Z

0

Use dd-mm-yyyy instead of dd-MM-yyyy.

answered Nov 5, 2012 at 15:54

Roy Dictus

33.3k9 gold badges64 silver badges77 bronze badges

1 Comment

Roy Dictus Over a year ago

Then your input string does not contain the months in numeric format? Check out the MSDN documentation at msdn.microsoft.com/en-us/library/az4se3k1.aspx

Collectives™ on Stack Overflow

C# DateTime Convert from String

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related