Standard Units

Database Management Reference Manual

Attributes : Real Attributes of Physical Quantities : Standard Units

There are a set of standard specific units that the system will understand. Ideally the unit qualifier should be appended to the value (e.g. 6.5inch) but often it can be recognised if separated from its value (e.g. 6.5 inch); but not always.

For each unit there is an abbreviated form, a long form, and a full form (which are often identical) (e.g. mm and millimetre). All can be understood including curtailed versions of the long form (e.g. metre and met etc.) always providing there are no other ambiguities. However in general, the long form will be necessary if the unit is solitary (i.e. not part of a compound unit) and especially if the unit qualifier is space separated from its value.

The set of standard units are:


Abbreviation	Long Name	Fullname	Hash Code	Physical Dimension
arcmin	arcmin	arcmin	ARCM	Angle
arcsec	arcsec	arcsec	ARCS	Angle
deg	degree	degree	DEG	Angle
grad	grad	grade	GRAD	Angle
rad	radian	radian	RAD	Angle
acre	acre	acre	ACRE	Area
ha	hectare	hectare	HECT	Area
F	farad	farad	FARA	Capacitance
C	coulomb	coulomb	COUL	Charge
mho	mho	mho	MHO	Conductance
Si	siemens	siemens	SIEM	Conductance
EUR	EUR	euro	EURO	Currency
GBP	GBP	GBPound	UKPD	Currency
USD	USD	USDollar	USDO	Currency
A	ampere	ampere	AMP	Current
V	volt	volt	VOLT	EMF
BTU	BTU	BTU	BTU	Energy
cal	calorie	calorie	CALO	Energy
J	joule	joule	JOUL	Energy
kWh	kWh	kiloWatthour	KWH	Energy
dyn	dyne	dyne	FORC	Force
kgf	kgf	kgForce	KGF	Force
lbf	lbf	poundForce	LBF	Force
N	newton	newton	NEWT	Force
pdl	pdl	poundal	PDL	Force
Hz	hertz	hertz	HERZ	Frequency
rpm	rpm	rpm	RPM	Frequency
ohm	ohm	ohm	OHM	Impedance
H	henry	henry	HENR	Inductance
Angst	angstrom	angstrom	ANGS	Length
cm	cm	centimetre	CM	Length
ft	ft	foot	FOOT	Length
in	in	inch	INCH	Length
in	inch	inch	FINC	Length
km	km	kilometre	KM	Length
m	metre	metre	METR	Length
micron	micron	micron	MICR	Length
mile	mile	mile	MILE	Length
mm	mm	millimetre	MM	Length
thou	thou	thou	THOU	Length
yd	yd	yard	YARD	Length
T	tesla	tesla	TESL	MagFluxDensity
Wb	weber	weber	WEBE	MagneticFlux
cwt	cwt	hundredweight	CWT	Mass
g	gram	gram	GRAM	Mass
kg	kg	kilogram	KG	Mass
lb	lb	pound	POUN	Mass
oz	oz	ounce	OZ	Mass
shortTon	shortTon	shortTon	STON	Mass
ton	longTon	longTon	TON	Mass
tonne	tonne	tonne	TONN	Mass
hp	hp	horsePower	HP	Power
kW	kW	kiloWatt	KWAT	Power
W	watt	watt	WATT	Power
atm	atm	atmosphere	ATM	Pressure
bar	bar	bar	BAR	Pressure
inHg	inHg	inHg	INHG	Pressure
mmHg	mmHg	mmHg	MMHG	Pressure
Pa	pascal	pascal	PASC	Pressure
PSI	PSI	PSI	PSI	Pressure
torr	torr	torr	TORR	Pressure
Gy	gray	gray	GRAY	RadiationDose
radD	raddose	radDose	RADD	RadiationDose
rem	rem	rem	REM	RadiationDose
Sv	sievert	sievert	SIEV	RadiationDose
Bq	bequerel	bequerel	BEQU	Radioactivity
Ci	curie	curie	CURI	Radioactivity
knot	knot	knot	KNOT	Speed
degC	degC	degCelsius	CELS	Temperature
degF	degF	degFahrenheit	FAHR	Temperature
degRan	degRan	degRankine	RANK	Temperature
K	kelvin	kelvin	KELV	Temperature
day	day	day	DAY	Time
hr	hour	hour	HOUR	Time
min	minute	minute	MINU	Time
mth	month	month	MONT	Time
s	second	second	SECO	Time
wk	week	week	WEEK	Time
yr	year	year	YEAR	Time
P	poise	poise	POIS	ViscosityDynamic
ImpGal	ImpGal	ImpGallon	GALI	Volume
l	litre	litre	LITR	Volume
USGal	USGal	USGallon	GALU	Volume

Where there are US and SI spelling alternatives BOTH versions are supported for example litre and liter, millimetre and millimeter etc.

Special Units for Combined Feet and Inches Units (FINCH)

There is a significant extension of input in feet and inches (so-called FINCH format).

A double quote (") may be used as a unit qualifier for inch in any context (decimal inch input, or finch input).

In FINCH format a single quote (') is accepted as an abbreviation for feet and must be used for non format controlled input) and a double quote for inches.

Note:

" and ' qualifiers are NOT accepted for minutes and seconds or arc units.

The feet and inch value is entered using both feet and inch unit qualifiers, and the fractional part of inches can either be entered as a decimal, 5'2.125" or as a fraction 5'2.1/8". The inch qualifier can be any inch qualifier or none (as it is syntactically redundant).

Additions for Format Controlled Finch Input

If the input is controlled by a format object the foot qualifier can be any foot qualifier (ft, foot, blip) and the inch qualifier can be placed after the integer inch value OR at the end of the inch value, or omitted.