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[3].DefaultCellStyle.Format = "hh:mm tt";

Any help would be appreciated!

Thanks,
Steven