C# DataGridView does not show seconds from a MySQL DateTime column

Question

0

I have in a MySQL database with the column type being DateTime the following time:

Timestamp:
9:34:09
9:34:23
9:34:45
9:34:50
9:35:09
9:36:17

But a DataGridView in C# only shows me
9:34
9:34
9:34
9:34
9:35
9:36

Why?

datagridview mysql

Edited 4 Years Ago by riahc3

3

Contributors

3

Replies

19

Views

4 Years

Discussion Span

4 Years Ago

Last Post by riahc3

This Question has been Answered

3

try to use Column.DefaultCellStyle.Format property or set it via designer....

Edited 4 Years Ago by Daemon_CC: improvement

datagridview mysql

ddanbe 2,720 · Answer 1 · 2014-04-24T11:21:51+00:00

Did you check the format of your string?
Format for DateTime strings can be found here.

riahc3 45 · Answer 2 · 2014-04-24T14:11:17+00:00

Solved it with this code:

 try 
            {
                dataGridView1.Columns["Time_Stamp"].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm:ss";

            }
            catch (Exception x)
            {

                MessageBox.Show(x.Message);
            }