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.
date format in queries
Re: date format in queries
We are aware of this issue and will fix it in the next product build.
Re: date format in queries
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.
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.
Re: date format in queries
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.
Thank you for your help in improving dbForge Studio for MySQL.
Re: date format in queries
Thanks! That's useful!