Devart Forums

the datetime in my database is '2020-01-06 22:51:38' but when I query the database it show in results grid '2020-01-06 10:51:38'.
How can I display it in 24Hr format ?

In my country the fomat is 'dd/mm/yyyy HH:mm:ss'. Is it possible to show it in my format ? It is not so important, but at least show it in 24hr format is very important.

We are aware of this issue and will fix it in the next product build.

Just updated from v8 to v9 (MySQL Express)

In the query result view, date, datetime and timestamp are displayed
as m-d-yyyy h:mm.ss (12H without AM/PM).

In Options -> Data Editor -> Formatting the format is yyyy-mm-dd hh:mm:ss
and that's how I would like to see my dates formatted.

I don't care how people like to format output around the world, I'd expect to
see data as defined by MySQL https://dev.mysql.com/doc/refman/8.0/en/datetime.html

Otherwise, a really cool tool. Perfect for Ad Hoc queries and updates.

We would like to let you know that we released dbForge Studio for MySQL, v9.0.338 where the issue you reported is fixed https://www.devart.com/dbforge/mysql/studio/download.html

Thank you for your help in improving dbForge Studio for MySQL.

Thanks! That's useful!