Login
Register
Contact Us
Search
Menu
Home
Products
XLeratorDB
function packages
for SQL Server
financial
view documentation
pricing
statistics
view documentation
pricing
math
view documentation
pricing
engineering
view documentation
pricing
strings
view documentation
pricing
financial-options
view documentation
pricing
windowing
view documentation
pricing
XLeratorDB
Compilation packages
for SQL Server
Suite
incl:
financial
,
statistics
,
math
,
engineering
&
strings
pricing
Suite (Developer)
requires SQL Server Developer Edition
pricing
Suite (Subscription)
One-year non-recurring license
pricing
SuitePLUS
incl: all Suite packages PLUS
financial-options
pricing
SuitePLUS (Developer)
requires SQL Server Developer Edition, also incl:
financial-options
pricing
SuitePLUS (Subscription)
One-year non-recurring license, also incl:
financial-options
pricing
XLeratorDLL
function packages
Microsoft .NET API Library
financial (DLL)
view documentation
pricing
SQL Server not required
View All Product Pricing ...
Download Free 15 Day Trial ...
Documentation
Purchase
XLeratorDB
function packages for
SQL Server (2008 & later)
financial
statistics
math
engineering
strings
financial-options
windowing
XLeratorDB
Compilation packages for
SQL Server (2008 & later)
Suite
Suite (Developer)
Suite (Subscription)
SuitePLUS
SuitePLUS (Developer)
SuitePLUS (Subscription)
XLeratorDLL
function packages
Microsoft .NET API Library
financial (DLL)
Legacy XLeratorDB Packages for
SQL Server 2005
financial
for SQL Server 2005 only
statistics
for SQL Server 2005 only
math
for SQL Server 2005 only
Suite
for SQL Server 2005 only
Suite (Developer)
for SQL Server 2005 only
SuitePLUS
for SQL Server 2005 only
SuitePLUS (Developer)
for SQL Server 2005 only
Download Trial
Case Studies
Blog
Support
XLeratorDB/engineering Online Documentation
Home
Search
Recent Changes
Show All Pages
Engineering Functions Index ...
Engineering Functions
Engineering
BESSELI - Bessel function of the second kind I±v(z)
BESSELJ - Bessel function of the first kind J±v(z)
BESSELK - Bessel function of the first kind Kv(z)
BESSELY - Bessel function of the first kind Yv(z)
DELTA - test whether two values are equal
ERF - error function
ERFC - complementary error function
GESTEP - test whether a number is greater than or equal to a threshold value
Modulo - amount by which a number exceeds the largest integer multiple of the divisor that is not greater than that number
Base Conversions
BIN2DEC - convert a binary number to a decimal
BIN2HEX - convert a binary number to a hexadecimal
BIN2OCT - convert a binary number to an octal
DEC2BIN - convert a decimal number to binary
DEC2HEX - convert a decimal number to hexadecimal
DEC2OCT - convert a decimal number to octal
EBIN2DEC - convert an unsigned positive binary number to decimal
HEX2BIN - convert a hexadecimal number to binary
HEX2DEC - convert a hexadecimal number to decimal
HEX2OCT - convert a hexadecimal number to octal
OCT2BIN - convert an octal number to binary
OCT2DEC - convert an octal number to decimal
OCT2HEX - convert an octal number to hexadecimal
Complex Numbers
COMPLEX - convert real and imaginary coefficients into a complex number of the form x + yi or x + yj
IMABS - absolute value of a complex number in the x + yi or x + yj format
IMADD - sum of 2 complex numbers in x + yi or x + yj text format
IMAGINARY - imaginary coefficient of a complex number in the x + yi or x + yj format
IMARGUMENT - theta, an angle expressed in radians
IMCONJUGATE - complex conjugate of a complex number in x + yi or x + yj format
IMCOS - cosine of a complex number in x + yi or x + yj text format
IMDIV - quotient of 2 complex numbers in x + yi or x + yj text format
IMEXP - exponential of a complex number in x + yi or x + yj text format
IMLN - natural logarithm of a complex number in x + yi or x + yj text format
IMLOG2 - base-2 logarithm of a complex number in x + yi or x + yj text format
IMLOG10 - common (base 10) logarithm of a complex number in x + yi or x + yj text format
IMMULT - product of 2 complex numbers in x + yi or x + yj text format
IMPOWER - complex number in x + yi or x + yj text format raised to a power
IMPRODUCT - product of a dataset containing complex numbers in x + yi or x + yj text format
IMPRODUCT_q - product of a dataset containing complex numbers in x + yi or x + yj text format
IMREAL - real coefficient of a complex number in the x + yi or x + yj format
IMSIN - sine of a complex number in x + yi or x + yj text format
IMSQRT - square root of a complex number in x + yi or x + yj text format
IMSUB - difference between 2 complex numbers in x + yi or x + yj text format
IMSUM - sum of a dataset of complex numbers in x + yi or x + yj text format
IMSUM_q - sum of a dataset of complex numbers in x + yi or x + yj text format
Unit Conversion Functions
Area
CONVERTAREA - convert to and from acres, hectares, square feet, square inches, square meters, square miles, or square yards
ACRES - convert area to acres
HECTARES - convert from area to hectares
SQFEET - convert from area to square feet
SQINCHES - convert from area to square inches
SQMETERS - convert from area to square meters
SQMILES - convert from area to square miles
SQYARDS - convert from area to square yards
Length
CONVERTLENGTH - convert to and from fathoms, feet, furlongs, inches, meters, miles, nautical miles, pica, points, or yards
FATHOMS - convert length to fathoms
FEET - convert length to feet
FURLONGS - convert length to furlongs
INCHES - convert length to inches
METERS - convert length to meters
MILES - convert length to miles
NMILES - convert length to nautical miles
PICA - convert length to pica
POINTS - convert length to points
YARDS - convert length to yards
Speed
CONVERTSPEED - convert to and from feet per hour, feet per minute, feet per second, inches per second, kilometers per hour, knots, miles per hour, miles per minute, miles per second, meters per second, meters per minute, or meters per hour
FTHR - convert speed to feet per hour
FTMIN - convert speed to feet per minute
FTSEC - convert speed to feet per second
INSEC - convert speed to inches per second
KMHR - convert speed to kilometers per hour
KNOTS - convert speed to knots
MHR - convert speed to meters per hour
MIHR - convert speed to miles per hour
MIMIN - convert speed to miles per minute
MISEC - convert speed to miles per second
MMIN - convert speed to meters per minute
MSEC - convert speed to meters per second
Temperature
CONVERTTEMP - convert to and from Celsius, Fahrenheit, Kelvin, or Rankine
CELSIUS - convert from Fahrenheit, Kelvin, or Rankine to Celsius
FAHRENHEIT - convert from Celsius, Kelvin, or Rankine to Fahrenheit
KELVIN - convert from Celsius, Fahrenheit, or Rankine to Kelvin
RANKINE - convert from Celsius, Fahrenheit, or Kelvin to Rankine
Volume
CONVERT VOLUME - convert to and from barrels (US beer barrels), bbl (oil barrel), bushels, cubic feet, cubic inches, cubic meters, cubic miles, cubic yards, cups, dry pints, dry quarts, fluid drams, fluid ounces, gallons, gills, imperial gallons, imperial gills, imperial pints, imperial quarts, liters, pecks, pints, quarts, steres, tablespoons, or teaspoons
BARRELS - convert area to barrels
BBLS - convert area to bbls
BUSHELS - convert area to bushels
CUFEET - convert volume to cubic feet
CUINCHES - convert volume to cubic inches
CUMETERS - convert volume to cubic meters
CUMILES - convert volume to cubic miles
CUPS - convert volume to cups
CUYARDS - convert volume to cubic yards
DRYPINTS - convert volume to dry pints
DRYQUARTS - convert volume to dry quarts
FLDRAMS - convert volume to fluid drams
FLOUNCES - convert volume to fluid ounces
GALLONS - convert volume to gallons
GILLS - convert volume to gills
IMPGALLONS - convert volume to imperial gallons
IMPGILLS - convert volume to imperial gills
IMPOUNCES - convert volume to imperial ounces
IMPPINTS - convert volume to imperial pints
IMPQUARTS - convert volume to imperial quarts
LITERS - convert volume to liters
PECKS - convert volume to pecks
PINTS - convert volume to pints
QUARTS - convert volume to quarts
STERES - convert volume to steres
TABLESPOONS - convert volume to tablespoons
TEASPOONS - convert volume to teaspoons
Weight
CONVERTWEIGHT - convert to and from drams, grains, grams, hundredweights, ounces, pennyweights, pounds, stones, tonnes, tons, troy pounds, or troy ounces
CWT - convert weight to hundredweights
DRAMS - convert weight to drams
DWT - convert weight to pennyweights
GRAINS - convert weight to grains
GRAMS - convert weight to troy pounds
OUNCES - convert weight to ounces
POUNDS - convert weight to pounds
STONES - convert weight to stones
TON - convert weight to tons
TONNES - convert weight to tonnes
TPOUNDS - convert weight to troy pounds
TROY - convert weight to troy ounces
Misc Functions
XLDB_ENGINEERING_VERSION - get version information for the XLeratorDB / engineering library
ALL FUNCTIONS (alpahbetical)
ACRES - convert area to acres
BARRELS - convert area to barrels
BBLS - convert area to bbls
BESSELI - Bessel function of the second kind I±v(z)
BESSELJ - Bessel function of the first kind J±v(z)
BESSELK - Bessel function of the first kind Kv(z)
BESSELY - Bessel function of the first kind Yv(z)
BIN2DEC - convert a binary number to a decimal
BIN2HEX - convert a binary number to a hexadecimal
BIN2OCT - convert a binary number to an octal
BUSHELS - convert area to bushels
CELSIUS - convert from Fahrenheit, Kelvin, or Rankine to Celsius
COMPLEX - convert real and imaginary coefficients into a complex number of the form x + yi or x + yj
CONVERT VOLUME - convert to and from barrels (US beer barrels), bbl (oil barrel), bushels, cubic feet, cubic inches, cubic meters, cubic miles, cubic yards, cups, dry pints, dry quarts, fluid drams, fluid ounces, gallons, gills, imperial gallons, imperial gills, imperial pints, imperial quarts, liters, pecks, pints, quarts, steres, tablespoons, or teaspoons
CONVERTAREA - convert to and from acres, hectares, square feet, square inches, square meters, square miles, or square yards
CONVERTLENGTH - convert to and from fathoms, feet, furlongs, inches, meters, miles, nautical miles, pica, points, or yards
CONVERTSPEED - convert to and from feet per hour, feet per minute, feet per second, inches per second, kilometers per hour, knots, miles per hour, miles per minute, miles per second, meters per second, meters per minute, or meters per hour
CONVERTTEMP - convert to and from Celsius, Fahrenheit, Kelvin, or Rankine
CONVERTWEIGHT - convert to and from drams, grains, grams, hundredweights, ounces, pennyweights, pounds, stones, tonnes, tons, troy pounds, or troy ounces
CUFEET - convert volume to cubic feet
CUINCHES - convert volume to cubic inches
CUMETERS - convert volume to cubic meters
CUMILES - convert volume to cubic miles
CUPS - convert volume to cups
CUYARDS - convert volume to cubic yards
CWT - convert weight to hundredweights
DEC2BIN - convert a decimal number to binary
DEC2HEX - convert a decimal number to hexadecimal
DEC2OCT - convert a decimal number to octal
DELTA - test whether two values are equal
DRAMS - convert weight to drams
DRYPINTS - convert volume to dry pints
DRYQUARTS - convert volume to dry quarts
DWT - convert weight to pennyweights
EBIN2DEC - convert an unsigned positive binary number to decimal
ERF - error function
ERFC - complementary error function
FAHRENHEIT - convert from Celsius, Kelvin, or Rankine to Fahrenheit
FATHOMS - convert length to fathoms
FEET - convert length to feet
FLDRAMS - convert volume to fluid drams
FLOUNCES - convert volume to fluid ounces
FTHR - convert speed to feet per hour
FTMIN - convert speed to feet per minute
FTSEC - convert speed to feet per second
FURLONGS - convert length to furlongs
GALLONS - convert volume to gallons
GESTEP - test whether a number is greater than or equal to a threshold value
GILLS - convert volume to gills
GRAINS - convert weight to grains
GRAMS - convert weight to troy pounds
HECTARES - convert from area to hectares
HEX2BIN - convert a hexadecimal number to binary
HEX2DEC - convert a hexadecimal number to decimal
HEX2OCT - convert a hexadecimal number to octal
IMABS - absolute value of a complex number in the x + yi or x + yj format
IMADD - sum of 2 complex numbers in x + yi or x + yj text format
IMAGINARY - imaginary coefficient of a complex number in the x + yi or x + yj format
IMARGUMENT - theta, an angle expressed in radians
IMCONJUGATE - complex conjugate of a complex number in x + yi or x + yj format
IMCOS - cosine of a complex number in x + yi or x + yj text format
IMDIV - quotient of 2 complex numbers in x + yi or x + yj text format
IMEXP - exponential of a complex number in x + yi or x + yj text format
IMLN - natural logarithm of a complex number in x + yi or x + yj text format
IMLOG10 - common (base 10) logarithm of a complex number in x + yi or x + yj text format
IMLOG2 - base-2 logarithm of a complex number in x + yi or x + yj text format
IMMULT - product of 2 complex numbers in x + yi or x + yj text format
IMPGALLONS - convert volume to imperial gallons
IMPGILLS - convert volume to imperial gills
IMPOUNCES - convert volume to imperial ounces
IMPOWER - complex number in x + yi or x + yj text format raised to a power
IMPPINTS - convert volume to imperial pints
IMPQUARTS - convert volume to imperial quarts
IMPRODUCT - product of a dataset containing complex numbers in x + yi or x + yj text format
IMPRODUCT_q - product of a dataset containing complex numbers in x + yi or x + yj text format
IMREAL - real coefficient of a complex number in the x + yi or x + yj format
IMSIN - sine of a complex number in x + yi or x + yj text format
IMSQRT - square root of a complex number in x + yi or x + yj text format
IMSUB - difference between 2 complex numbers in x + yi or x + yj text format
IMSUM - sum of a dataset of complex numbers in x + yi or x + yj text format
IMSUM_q - sum of a dataset of complex numbers in x + yi or x + yj text format
INCHES - convert length to inches
INSEC - convert speed to inches per second
KELVIN - convert from Celsius, Fahrenheit, or Rankine to Kelvin
KMHR - convert speed to kilometers per hour
KNOTS - convert speed to knots
LITERS - convert volume to liters
METERS - convert length to meters
MHR - convert speed to meters per hour
MIHR - convert speed to miles per hour
MILES - convert length to miles
MIMIN - convert speed to miles per minute
MISEC - convert speed to miles per second
MMIN - convert speed to meters per minute
Modulo - amount by which a number exceeds the largest integer multiple of the divisor that is not greater than that number
MSEC - convert speed to meters per second
NMILES - convert length to nautical miles
OCT2BIN - convert an octal number to binary
OCT2DEC - convert an octal number to decimal
OCT2HEX - convert an octal number to hexadecimal
OUNCES - convert weight to ounces
PECKS - convert volume to pecks
PICA - convert length to pica
PINTS - convert volume to pints
POINTS - convert length to points
POUNDS - convert weight to pounds
QUARTS - convert volume to quarts
RANKINE - convert from Celsius, Fahrenheit, or Kelvin to Rankine
SQFEET - convert from area to square feet
SQINCHES - convert from area to square inches
SQMETERS - convert from area to square meters
SQMILES - convert from area to square miles
SQYARDS - convert from area to square yards
STERES - convert volume to steres
STONES - convert weight to stones
TABLESPOONS - convert volume to tablespoons
TEASPOONS - convert volume to teaspoons
TON - convert weight to tons
TONNES - convert weight to tonnes
TPOUNDS - convert weight to troy pounds
TROY - convert weight to troy ounces
XLDB_ENGINEERING_VERSION - get version information for the XLeratorDB / engineering library
YARDS - convert length to yards
XLDB_CONVERT_VERSION
View Topic History