MVC C# DateTime formatting fix needed

Question

As you can see in the below screen shot. I have Date which is 7/12/2011 12:00:00 AM. Date is described wrong even if I format it. 7 should be the day and 12 is the month.

How I fix that to get proper formatting for yellow return string?

Date formatting problem

In the below screen shot the Date is 28/12/2011 11:00 where 28 is day and 12 is month. Trying to convert that string into DateTime to save into SQL Server DateTime field but gives conversion problem. Anyone tell me why is that and How to fix it?

Date conversion

Solution:

I solved problem like below. When I want saving date in SQL Server 2008 r2 the default was saved like 2011-08-12 11:00:00.000 which was causing problem. I changed that formatting Date when it was going to be saved in SQL like below and it worked

DateTime n = Convert.ToDateTime(start_date);

            var h = String.Format("{0:dd/MM/yyyy}", n);

            if (start_date != "")
            {
                changedEvent.start_date = Convert.ToDateTime(h);
            }

Output now is 2011-12-08 11:00:00.000. Do you think any clean work around?

Edited my question and added workaround which worked.

Pirzada
– Pirzada

2011-12-07 17:28:13 +00:00
Commented Dec 7, 2011 at 17:28 — Pirzada
– Pirzada, Commented Dec 7, 2011 at 17:28

SLaks · Accepted Answer · 2011-12-07 03:36:07Z

1

You should call DateTime.ParseExact(start_date, "dd/MM/yyyy", CultureInfo.InvariantCulture)

answered Dec 7, 2011 at 3:36

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

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

Comments

ysrb · Accepted Answer · 2011-12-07 03:36:31Z

0

Try:

DateTime.ParseExact(str, "dd/MM/yyyy HH:mm:ss TT", null); //28/12/2011 11:00:00 AM
DateTime.ParseExact(str, "dd/MM/yyyy HH:mm", null); //28/12/2011 11:00

answered Dec 7, 2011 at 3:36

ysrb

6,7202 gold badges32 silver badges30 bronze badges

Comments

Erik Funkenbusch · Accepted Answer · 2011-12-07 04:33:58Z

0

I think you are addressing the wrong problem. If you want DateTime to recognize your locale date format, then you should make sure the servers date locale is set for your local one. Then, DateTime will convert the date correctly without conversion.

If that's not possible (say you're using a shared server in a different locale) then the ParseExact method would be one solution, but it will only fix some of the problem. For instance, dates posted and model bound will attempt to parse in the servers locale format.

You may need to set your locale explicitly, using something like this:

Thread.CurrentThread.CurrentUICulture = new CultureInfo("es-MX");

answered Dec 7, 2011 at 4:33

Erik Funkenbusch

93.7k29 gold badges201 silver badges292 bronze badges

Collectives™ on Stack Overflow

MVC C# DateTime formatting fix needed

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related