Page 1 of 1

Time Format in Select

Posted: Sat 18 Dec 2021 12:42
by KierLancaster
Hello Everybody,

The tool dbForge for MySQL is used.

If date values are output in the tool in a select query, the order of the information (month, day, year) is unusual. In addition, the times are only displayed in the 12 hour format and not in the 24 hour format. 10.0.0.0.1 192.168.10.1 routerlogin


Can someone tell me how to adjust the date format and time format on the display?

Re: Time Format in Select

Posted: Sun 19 Dec 2021 16:41
by alexa
You can specify the following string in the 'Data Editor -> Formatting' section of the 'Options' window:
dd/MM/yyyy hh:mm:ss.fff
Image