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 8.x or above

To define the Date and Time format:

Version 11.2 or below

1. Choose Tools > Options > Appearance > Data & Grid.
2. Under Display Format, enter your preferable styles in the Date, Time and DateTime text boxes.
   

Version 12 or above

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