date format in queries

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Pedroprt
Posts: 1
Joined: Tue 02 Jun 2020 02:57

date format in queries

Post by Pedroprt » Tue 02 Jun 2020 03:10

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.

alexa

Re: date format in queries

Post by alexa » Tue 02 Jun 2020 08:19

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

TrasherDK
Posts: 1
Joined: Thu 04 Jun 2020 15:48

Re: date format in queries

Post by TrasherDK » Thu 04 Jun 2020 16:17

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.

alexa

Re: date format in queries

Post by alexa » Wed 24 Jun 2020 13:52

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.

AlexBrown
Posts: 6
Joined: Wed 06 Jun 2018 11:02
Contact:

Re: date format in queries

Post by AlexBrown » Tue 28 Jul 2020 11:22

Thanks! That's useful!

Post Reply