How to convert a DB2 timestamp to datetime?

Question

How to convert a timestamp returned from DB2 ISeries to a DateTime data type in C #?

2012-07-06 09:52:50.926145

It didn’t work for me

myEmployee.LastModified = Convert.ToDateTime(myRecord.GetString(myRecord.GetOrdinal("LASTMODIFIED")));

+5

Zo has Jul 6 '12 at 4:54

2 answers

You can do it with DateTime.TryParse()

DateTime date;
DateTime.TryParse("2012-07-06 09:52:50.926145", out date);

In your case

DateTime date,
DateTime.TryParse(myRecord.GetString(myRecord.GetOrdinal("LASTMODIFIED")), out date);

+1

Asif mushtaq Jul 6 '12 at 4:55

Ryan · Accepted Answer · 2012-07-06T04:56:11+0000

DateTime result = DateTime.Parse("2012-07-06 09:52:50.926145");