Member Avatar for steven8579
steven8579 11 Light Poster

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

  • 1 Contributor
  • 0 Replies
  • 352 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.