formatting time in a datagrid

[larthur1022]

I want my data grid to show the extended time (MM/dd/yyyy HH:mm:ss tt), and it does this, but for times where the hour is 12:00 AM, it only shows "00" for "12" for a 24-hour day. Can I fix this throught .NET or do I have to change the SQL statement that is pulling the date?

 

[fomhoire]

try using: (MM/dd/yyyy hh:mm:ss tt)