Where to set the time format?

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
dbforge noob
Posts: 3
Joined: Tue 03 Feb 2015 02:51

Where to set the time format?

Post by dbforge noob » Tue 03 Feb 2015 03:02

I'm sorry to bother you guys but I've tried for hours attempting to find the answer for myself through google and tutorials.

What I have is a table that has a time column and I know that somewhere probably in the data editor there is an option to select the format of that column as per this link from the help section for dbforge studio.
https://www.devart.com/dbforge/sql/stud ... og_box.htm

I can select the data type for that column but how or where do I select the format?

Thank you for any help, it is greatly appreciated. :D

alexa

Re: Where to set the time format?

Post by alexa » Tue 03 Feb 2015 10:54

This can be setup as follows:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Data Editor -> Formatting' branch.
3. Select 'DateTime' from the 'Data type' drop-down menu.
4. Select one of the predefined formats in the 'Predefined Formats' list.
5. Click 'OK'.

Post Reply