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?
Time Format in Select
-
KierLancaster
- Posts: 1
- Joined: Sat 18 Dec 2021 12:38
Time Format in Select
Last edited by KierLancaster on Sun 26 Dec 2021 01:45, edited 1 time in total.
-
alexa
Re: Time Format in Select
You can specify the following string in the 'Data Editor -> Formatting' section of the 'Options' window:
dd/MM/yyyy hh:mm:ss.fff
dd/MM/yyyy hh:mm:ss.fff