When viewing data, the below settings apply.
Font & Formatting settings
The data browsing grids and grids in the Table Editor and View Editor use the Font size in the settings above. The small grid is an example.
Formatting
Integer base data and floating point based data use the formatting settings in the first two boxes. The following characters are accepted:
0 |
Digit placeholder. If the value being formatted has a digit in the position where the "0" appears in the format string, then that digit is copied to the output string. Otherwise, a "0" is stored in that position in the output string.
|
# |
Digit placeholder. If the value being formatted has a digit in the position where the "#" appears in the format string, then that digit is copied to the output string. Otherwise, nothing is stored in that position in the output string.
|
. |
Decimal point. The first "." character in the format string determines the location of the decimal separator in the formatted value; any additional "." characters are ignored. The actual character for the decimal separator is specified in the Number Format of the Regional Settings section in the Windows Control Panel.
|
, |
Thousand separator. If the format string contains one or more "," characters, the output will have thousand separators inserted between each group of three digits to the left of the decimal point. The placement and number of "," characters in the format string does not affect the output, except to indicate that thousand separators are wanted. The actual character used as a the thousand separator in the output is determined by thousand separator is specified in the Number Format of the Regional Settings section in the Windows Control Panel. |
Date & Time based data use the formatting settings in the next 3 boxes, if you clear them, Database Workbench will use the Windows Control Panel settings.
d or dd |
The day as a number, using "dd" means it includes a leading zero.
|
ddd or dddd |
The day as a textual representation, the short format means using an abbreviation, the long format means the full textual representation.
|
m or mm |
The month as a number, using "mm" means it includes a leading zero.
|
mmm or mmmm |
The month as a textual representation, the short format means using an abbreviation, the long format means the full textual representation.
|
yy or yyyy |
The year as a two digit or four digit number.
|
h or hh |
The hour as a number, using "hh" means it includes a leading zero.
|
n or nn |
The minutes as a number, using "nn" means it includes a leading zero.
|
s or ss |
The seconds as a number, using "ss" means it includes a leading zero.
|
/ |
The date separator as specified in the Windows Control Panel.
|
: |
The time separator as specified in the Windows Control Panel. |