Date format Issue in SQL Server or ASP.NET

Question

When I run a stored procedure in SQL Server 2008 CTP I get date "2012-10-31 00:00:00.000" with this format.

But when I am converting it using

Convert.ToString(drConversation["ConversationDate"])

in C#, I am getting "10/31/2012 12:00:00 AM".

Where should be problem? In C# code or in SQL Server?

You can easily call Convert.ToDateTime(drConversation["ConversationDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff") in C# and get the exact same format as SQL Server returns - so what is the REAL problem here?? I don't see any issue.... — marc_s
– marc_s, Commented Oct 31, 2012 at 13:53
Data Masseur: When I am parsing string to Date time I have error. The error=> " DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar." — Chirag Khatsuriya
– Chirag Khatsuriya, Commented Oct 31, 2012 at 13:53
Marc_s : DateTimeParseExcect(Convert.ToString(drConversation["ConversationDate"])) In function : I am returning DateTime.ParseExact(DateValue.Substring(0,10),DateExectParse, null); and My "DateExectParse" is format "dd/MM/yyyy". — Chirag Khatsuriya
– Chirag Khatsuriya, Commented Oct 31, 2012 at 13:54

John Woo · Accepted Answer · 2012-10-31 13:48:49Z

1

There is no problem with it, The SQLServer use 24-hr format while the output from Convert class outputs 12-hr format.

answered Oct 31, 2012 at 13:48

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

3 Comments

Chirag Khatsuriya Over a year ago

then why date format is change from"YYY-dd-mm" to "MM/dd/YYYY"?

John Woo Over a year ago

because it is by default. do you want it to retain the format?

John Woo Over a year ago

@chiragKhatsuriya you can use Convert.ToDateTime(drConversation["ConversationDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff")

Blachshma · Accepted Answer · 2012-10-31 13:52:33Z

1

Actually it is the same date but in a different format.

If you would like to see it in the same format as in the Sql Server you can use:

DateTime.Parse(drConversation["ConversationDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss")

answered Oct 31, 2012 at 13:52

Blachshma

17.5k4 gold badges62 silver badges73 bronze badges

1 Comment

pseudocoder Over a year ago

Why would you convert to string, then to Date, then back to string? ((Date) drConversation["ConversationDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff") should do it right?

huMpty duMpty · Accepted Answer · 2012-10-31 14:55:30Z

0

Try this way

DateTime mydate= Convert.ToDateTime(drConversation["ConversationDate"].ToString());

answered Oct 31, 2012 at 14:55

huMpty duMpty

14.5k14 gold badges64 silver badges102 bronze badges

Collectives™ on Stack Overflow

Date format Issue in SQL Server or ASP.NET

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related