How can I display the Date and Time in my specific format?

Apply OS: Windows, Linux

Apply Navicat Product: All

Apply Navicat Version No.: Version 12 or above

To define the Date and Time format:

1. Choose Tools > Options.
2. Select Records.
3. Under Display Format, enter your preferable styles in the Date, Time and DateTime text boxes.