Page 1 of 1

Where to set the time format?

Posted: Tue 03 Feb 2015 03:02
by dbforge noob
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

Re: Where to set the time format?

Posted: Tue 03 Feb 2015 10:54
by alexa
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'.