>>
>>sbResult.AppendFormat("{0,20}", row.Field<DateTime?>("date_time").ToString("G"));
>>
>>But how to get rid of last AM/PM (BTW, not sure why VFP is removing it as the time will be ambiguous). Same thing of getting rid of last 3 chars?
>
>It shows you sample output from the different formats. All you have to do is read ...
If you saw in my response to Gregory, I think VFP result was wrong. I already sent email to my colleagues and they seemed to confirm it. So, I will be just using g format.
If it's not broken, fix it until it is.
My Blog