Unable to parse DateTime from SQL using C#

Question

I am relatively new to C# and any suggestions to the query below i will greatly appreciate.

I've gone through a lot of articles here but none of the solutions seems to work in my case

Im reading DATETIME from sql and passing it to a string

dateStart = rd1["DATE_START"].ToString();

when debugging in VS it's showing date time in a format i like: 22/11/2015 17:12:45 But Label is showing 11/22/2015 5:12:45 PM

When i use the code to ParseExact

dtime = DateTime.ParseExact(dateStart, "yyyy/MM/dd HH:mm:ss", provider);

No matter what i use for the format i always get

[FormatException: String was not recognized as a valid DateTime.]

DateTime dtime;
CultureInfo provider = CultureInfo.InvariantCulture;
provider = new CultureInfo("en-GB");
dateStart = rd1["DATE_START"].ToString();
dtime = DateTime.ParseExact(dateStart, "yyyy/MM/dd HH:mm:ss", provider);
LBDateOpened.Text = dtime.ToString();

I'm lost, please help.

Are you sure your query isn't returning an actual DATETIME type? If that were the case, you could just (DateTime)rd1["DATE_START"], which is significantly better than parsing it yourself. — Cory Nelson
– Cory Nelson, Commented Nov 24, 2015 at 20:50
The format string in ParseExact doesn't look, well, exact to the source string. — David
– David, Commented Nov 24, 2015 at 20:54
Thank you @CoryNelson. Your suggestion worked! dtime= (DateTime)rd1["DATE_START"]; LBDateOpened.Text = dtime.ToString("yyyy/mm/dd HH:mm:ss"); — Luke
– Luke, Commented Nov 24, 2015 at 20:58

ragerory · Accepted Answer · 2015-11-24 20:55:36Z

2

Following should work fine...

var dateStart = (DateTime)rd1["DATE_START"]; // assign DateTime
var dateString = dateStart.ToString("yyyy/MM/dd HH:mm:ss"); // format to string

answered Nov 24, 2015 at 20:55

ragerory

1,3761 gold badge10 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Unable to parse DateTime from SQL using C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related