Vb.net DateTime conversion from String

Question

I am getting this datetime format in an xml file:

2012-06-14T11:15:41.587-07:00
2012-06-14T10:49:32.397-07:00
2012-06-11T11:10:49.2-07:00

I believe I understand some of it, please correct me if I am wrong:

2012-06-14 = date

T = time identifier

10:49:32.397 = hour min second milliseconds

-07:00 = I have no idea

I need to convert this to something I can sort on for my datagrid view.

When I try something like this:

Console.WriteLine(String.Format("{0:d/M/yyyy HH:mm:ss}", "2012-06-14T10:49:32.397-07:00"))

I'm getting the original string back out with no conversion.

Anyone have any suggestions?

vcsjones · Accepted Answer · 2012-06-18 16:26:37Z

4

-07:00 = I have no idea

-7 is a timezone offset. It means the DateTime is 7 hours behind UTC, which would indicate the US Mountain Time.

You want to use DateTime.Parse to get a DateTime object.

Dim val As String = "2012-06-11T11:10:49.2-07:00"
Dim parsedDateTime As DateTime = DateTime.Parse(val)
'Do whatever with parsedDateTime here

answered Jun 18, 2012 at 16:26

vcsjones

142k34 gold badges301 silver badges295 bronze badges

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

4 Comments

ErocM Over a year ago

worked perfect although how do I get this as a DefaultCellStyle.Format for a datagridview column though? Do I need to convert each cell's value? I know I didn't clarify that in the question.

vcsjones Over a year ago

@ErocM That sounds like a different (new) question. I assume you are talking about DataGridView, which I don't have a lot of background in.

ErocM Over a year ago

k you've got me started, I'll post a new question. Tyvm!!

Mike_OBrien Over a year ago

If you are using a datagridview and you know the columsn that will be present at run time, you can set the columns up in the designer. Using VS 2008 when you select the datagridview a little arrow will show up on the top right. click that then an item on that menu will be Add Columns and Edit Columns. you can use the screens that those bring up to add all the columns you want and assign them datatypes and formats in there, some of the attributes are a little buried but just poke around a bit and you'll find what you need. (character limit is cutting me off, sorry)

Wayne Werner · Accepted Answer · 2012-06-18 16:28:08Z

0

Take a look at this article:

http://msdn.microsoft.com/en-us/library/1k1skd40.aspx

It should give you a better grasp of how to use the DateTime object. The time you have is the ISO 8601 format.

answered Jun 18, 2012 at 16:28

Wayne Werner

52.3k35 gold badges213 silver badges304 bronze badges

Comments

Reed Copsey · Accepted Answer · 2012-06-18 16:28:35Z

0

The -07:00 is the offset from UTC. You can parse this via DateTimeOffset.ParseExact, which includes a specifier for the offset ("zzz" format specifier).

In your case, I believe this would be :

Dim xmlValue = "2012-06-14T11:15:41.587-07:00"

Dim value as DateTimeOffset = DateTimeOffset.ParseExact(xmlValue, "yyyy-MM-dd\Thh:mm:ss.fffzzz", CultureInfo.InvariantCulture)

answered Jun 18, 2012 at 16:28

Reed Copsey

567k80 gold badges1.2k silver badges1.4k bronze badges

1 Comment

vcsjones Over a year ago

The standard Parse method knows how to parse ISO 8601 dates, but this works too.

Collectives™ on Stack Overflow

Vb.net DateTime conversion from String

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related