-
Notifications
You must be signed in to change notification settings - Fork 3.3k
Managing Data Formats
The DBeaver formatting functions allow you to set up database locale and change datasource format settings. This feature can be very useful on data migration, for example.
To change data format setting use option Window -> Preferences in main menu.
In the Preferences dialog box go to Database -> Editors -> DataEditor -> Data Formats
Or, in the Project Navigator area right-click a connection and select Edit Connection menu option. In the right area of the opened Data formatting preferences dialog window go to Result Sets -> Data Formatting, and select Datasource settings check box in the left area.
Data format profiles allow you to apply a set of data format preferences to the whole current project by one click.
To create a data format profile press the Manage Profiles button. In the opened dialog window press button New Profile, define the name and press Create.
To delete a data format profile press the Manage Profiles button. In the opened dialog window select the profile you want to delete and press the button Delete Profile.
The following data formats of columns and parameters can be adjusted:
To define this setting select a language, country and variant if available.
Select Use native date/time format check-box and the data format originally built-in to the datasource will be used.
You can change the format of the following data types:
The default value for this data type is yyyy-MM-dd.
The default value for this data type is HH:mm:ss
The default value for this data type is yyyy-MM-dd HH:mm:ss
The following parameters can be configured from thisy type of data:
- Use Grouping - Long numbers can be hard to read if they have too many digits. For example, the factorial of 30 is 33 digits long! Select this check-box to enable Grouping mode, in which digits are displayed in clumps of 3 or 4 (depending on the current radix) separated by commas.
- Maximum integer digits - Defines the maximum number of digits to the left of the decimal point.
- Minimum integer digits - Defines the minimum number of digits to the left of the decimal point.
- Maximum fraction digits - Defines the maximum number of digits to the right of the decimal point.
- Minimum fraction digits - Defines the minimum number of digits to the right of the decimal point.
- Use data type scale for fraction digits - Some numeric columns or parameters may have a predefined scale, that is the maximum number of digits to the right of the decimal point. Select this check-box if you want the predefined precision to be used.
- Rounding mode - Specifies a rounding behavior for numerical operations capable of discarding precision. Each rounding mode indicates how the least significant returned digit of a rounded result is to be calculated. To learn more, please refer to Oracle documentation.
To change the data type format, change the value displayed in the Pattern area and observe the expected result in the Sample field. To save the changes made, press the Apply button.
To restore the default data format settings, press the Restore Defaults button.
Press Datasource settings link to change data format settings for a particular datasource and adjust the settings in the opened dialog box.
-
Views
-
Search
-
Data management
-
Usability enhancements
-
Security
-
Projects
- Sample Database
-
Database Connections
- Edit Connection
- Invalidate/Reconnect to Database
- Disconnect from Database
- Change current user password
- Advanced settings
- Cloud configuration settings
- Local Client Configuration
- Connection Types
- Configure Connection Initialization Settings
-
Tableau integration
- Transactions
- Drivers
- Tasks
-
Cloud Explorer
-
Cloud Storage
- Classic
- Cloud
- Changing interface language
- DBeaver extensions - Office, Debugger, SVG
- Installing extensions - Themes, version control, etc
- User Interface Themes
- Command Line
- Reset UI settings
- Reset workspace
- Troubleshooting system issues
- Posting issues
- Log files
- JDBC trace
- Thread dump
- Managing connections
- Managing variables
- Managing drivers
- Managing preferences
- Managing restrictions
- Windows Silent Install
- Snap installation