I have an sql database names SubJobs with a column named Date. The data type is Time(7). I have a datagridview named DataGridView1. I want it to display a time like 04:30 PM. I’ve tried the following command to format the column but it gives me an error saying that it can’t be converted.
dataGridView1.Columns.DefaultCellStyle.Format = "hh:mm tt";
Any help would be appreciated!