Skip to content

API Docs - v1.0.13

Unitconversion

MmTokm (Function)

Converts the input megameters into kilometers

Syntax

<DOUBLE> unitconversion:MmTokm(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from megameters into kilometers INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForMegametreToKilometreStream (inValue int); 
from UnitConversionForMegametreToKilometreStream 
select unitconversion:MmTokm(inValue) as UnitConversionValue 
insert into OutMediationStream;

The megameters values from UnitConversionForMegametreToKilometreStream will be converted to kilometers and inserted in to the OutMediationStream

cmToft (Function)

Converts the input centimeters into feet

Syntax

<DOUBLE> unitconversion:cmToft(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from centimeters to feet INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForCentimetreToFootStream (inValue int); 
from UnitConversionForCentimetreToFootStream 
select unitconversion:cmToft(inValue) as UnitConversionValue 
insert into OutMediationStream;

The centimeter values from UnitConversionForCentimetreToFootStream will be converted to feet and inserted in to the OutMediationStream

cmToin (Function)

Converts the input centimeters into inches

Syntax

<DOUBLE> unitconversion:cmToin(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from centimeters into inches INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForCentimetreToInchStream (inValue int); 
from UnitConversionForCentimetreToInchStream 
select unitconversion:cmToin(inValue) as UnitConversionValue 
insert into OutMediationStream;

The centimeter values from UnitConversionForCentimetreToInchStream will be converted to inches and inserted in to the OutMediationStream

cmTokm (Function)

Converts the input centimeters into kilometers

Syntax

<DOUBLE> unitconversion:cmTokm(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from centimeters into kilometers INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForCentimetreToKilometreStream (inValue int); 
from UnitConversionForCentimetreToKilometreStream 
select unitconversion:cmTokm(inValue) as UnitConversionValue 
insert into OutMediationStream;

The centimeter values from UnitConversionForCentimetreToKilometreStream will be converted to kilometers and inserted in to the OutMediationStream

cmTom (Function)

Converts the input centimeters into meters

Syntax

<DOUBLE> unitconversion:cmTom(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from centimeters into meters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForCentimetreToMeterStream (inValue int); 
from UnitConversionForCentimetreToMeterStream 
select unitconversion:cmTom(inValue) as UnitConversionValue 
insert into OutMediationStream;

The centimeter values from UnitConversionForCentimetreToMeterStream will be converted to meters and inserted in to the OutMediationStream

cmTomi (Function)

Converts the input centimeters into miles

Syntax

<DOUBLE> unitconversion:cmTomi(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from centimeters into miles INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForCentimetreToMileStream (inValue int); 
from UnitConversionForCentimetreToMileStream 
select unitconversion:cmTomi(inValue) as UnitConversionValue 
insert into OutMediationStream;

The centimeter values from UnitConversionForCentimetreToMileStream will be converted to miles and inserted in to the OutMediationStream

cmTomm (Function)

Converts the input centimeters into millimeters

Syntax

<DOUBLE> unitconversion:cmTomm(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from centimeters into millimeters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForCentimetreToMillimetreStream (inValue int); 
from UnitConversionForCentimetreToMillimetreStream 
select unitconversion:cmTomm(inValue) as UnitConversionValue 
insert into OutMediationStream;

The centimeter values from UnitConversionForCentimetreToMillimetreStream will be converted to millimeters and inserted in to the OutMediationStream

cmTonm (Function)

Converts the input centimeters into nanometers

Syntax

<DOUBLE> unitconversion:cmTonm(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from centimeters into nanometers INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForCentimetreToNanometreStream (inValue int); 
from UnitConversionForCentimetreToNanometreStream 
select unitconversion:cmTonm(inValue) as UnitConversionValue 
insert into OutMediationStream;

The centimeter values from UnitConversionForCentimetreToNanometreStream will be converted to nanometers and inserted in to the OutMediationStream

cmToum (Function)

Converts the input centimeters into micrometers

Syntax

<DOUBLE> unitconversion:cmToum(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from centimeters into micrometers INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForCentimetreToMicrometreStream (inValue int); 
from UnitConversionForCentimetreToMicrometreStream 
select unitconversion:cmToum(inValue) as UnitConversionValue 
insert into OutMediationStream;

The centimeter values from UnitConversionForCentimetreToMicrometreStream will be converted to micrometers and inserted in to the OutMediationStream

cmToyd (Function)

Converts the input centimeters into yards

Syntax

<DOUBLE> unitconversion:cmToyd(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from centimeters into yards INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForCentimetreToYardStream (inValue int); 
from UnitConversionForCentimetreToYardStream 
select unitconversion:cmToyd(inValue) as UnitConversionValue 
insert into OutMediationStream;

The centimeter values from UnitConversionForCentimetreToYardStream will be converted to yards and inserted in to the OutMediationStream

dToh (Function)

Converts the input days into hours

Syntax

<DOUBLE> unitconversion:dToh(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from days into hours INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForDayToHourStream (inValue int); 
from UnitConversionForDayToHourStream 
select unitconversion:dToh(inValue) as UnitConversionValue 
insert into OutMediationStream;

The day values from UnitConversionForDayToHourStream will be converted to hours and inserted in to the OutMediationStream

gTokg (Function)

Converts the input grams into kilograms

Syntax

<DOUBLE> unitconversion:gTokg(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from grams into kilograms INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForGramToKilogramStream (inValue int); 
from UnitConversionForGramToKilogramStream 
select unitconversion:gTokg(inValue) as UnitConversionValue 
insert into OutMediationStream;

The gram values from UnitConversionForGramToKilogramStream will be converted to kilograms and inserted in to the OutMediationStream

gTomg (Function)

Converts the input grams into milligrams

Syntax

<DOUBLE> unitconversion:gTomg(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from grams into milligrams INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForGramToMilligramStream (inValue int); 
from UnitConversionForGramToMilligramStream 
select unitconversion:gTomg(inValue) as UnitConversionValue 
insert into OutMediationStream;

The gram values from UnitConversionForGramToMilligramStream will be converted to milligrams and inserted in to the OutMediationStream

gToug (Function)

Converts the input grams into micrograms

Syntax

<DOUBLE> unitconversion:gToug(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from grams into micrograms INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForGramToMicrogramStream (inValue int); 
from UnitConversionForGramToMicrogramStream 
select unitconversion:gToug(inValue) as UnitConversionValue 
insert into OutMediationStream;

The gram values from UnitConversionForGramToMicrogramStream will be converted to micrograms and inserted in to the OutMediationStream

hTom (Function)

Converts the input hours into minutes

Syntax

<DOUBLE> unitconversion:hTom(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from hours into minutes INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForHourToMinuteStream (inValue int); 
from UnitConversionForHourToMinuteStream 
select unitconversion:hTom(inValue) as UnitConversionValue 
insert into OutMediationStream;

The hour values from UnitConversionForHourToMinuteStream will be converted to minutes and inserted in to the OutMediationStream

hTos (Function)

Converts the input hours into seconds

Syntax

<DOUBLE> unitconversion:hTos(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from hours into seconds INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForHourToSecondStream (inValue int); 
from UnitConversionForHourToSecondStream 
select unitconversion:hTos(inValue) as UnitConversionValue 
insert into OutMediationStream;

The hour values from UnitConversionForHourToSecondStream will be converted to seconds and inserted in to the OutMediationStream

kgToLT (Function)

Converts the input kilograms into imperial tons

Syntax

<DOUBLE> unitconversion:kgToLT(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilograms into imperial tons INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilogramToImperialTonStream (inValue int); 
from UnitConversionForKilogramToImperialTonStream 
select unitconversion:kgToLT(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilogram values from UnitConversionForKilogramToImperialTonStream will be converted to imperial tons and inserted in to the OutMediationStream

kgToST (Function)

Converts the input kilograms into US tons

Syntax

<DOUBLE> unitconversion:kgToST(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilograms into US tons INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilogramToUSTonStream (inValue int); 
from UnitConversionForKilogramToUSTonStream 
select unitconversion:kgToST(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilogram values from UnitConversionForKilogramToUSTonStream will be converted to US tons and inserted in to the OutMediationStream

kgTog (Function)

Converts the input kilograms into grams

Syntax

<DOUBLE> unitconversion:kgTog(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilograms into grams INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilogramToGramStream (inValue int); 
from UnitConversionForKilogramToGramStream 
select unitconversion:kgTog(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilogram values from UnitConversionForKilogramToGramStream will be converted to grams and inserted in to the OutMediationStream

kgTolb (Function)

Converts the input kilograms into pounds

Syntax

<DOUBLE> unitconversion:kgTolb(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilograms into pounds INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilogramToPoundStream (inValue int); 
from UnitConversionForKilogramToPoundStream 
select unitconversion:kgTolb(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilogram values from UnitConversionForKilogramToPoundStream will be converted to pounds and inserted in to the OutMediationStream

kgTooz (Function)

Converts the input kilograms into ounces

Syntax

<DOUBLE> unitconversion:kgTooz(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilograms into ounces INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilogramToOunceStream (inValue int); 
from UnitConversionForKilogramToOunceStream 
select unitconversion:kgTooz(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilogram values from UnitConversionForKilogramToOunceStream will be converted to ounces and inserted in to the OutMediationStream

kgTost (Function)

Converts the input kilograms into imperial stones

Syntax

<DOUBLE> unitconversion:kgTost(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilograms into imperial stones INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilogramToStonemStream (inValue int); 
from UnitConversionForKilogramToStonemStream 
select unitconversion:kgTost(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilogram values from UnitConversionForKilogramToStonemStream will be converted to imperial stones and inserted in to the OutMediationStream

kgTot (Function)

Converts the input kilograms into Tonnes

Syntax

<DOUBLE> unitconversion:kgTot(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilograms into Tonnes INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilogramToTonneStream (inValue int); 
from UnitConversionForKilogramToTonneStream 
select unitconversion:kgTot(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilogram values from UnitConversionForKilogramToTonneStream will be converted to Tonnes and inserted in to the OutMediationStream

kmTocm (Function)

Converts the input kilometers into centimeters

Syntax

<DOUBLE> unitconversion:kmTocm(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilometers into centimeters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilometreToCentimetreStream (inValue int); 
from UnitConversionForKilometreToCentimetreStream 
select unitconversion:kmTocm(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilometer values from UnitConversionForKilometreToCentimetreStream will be converted to centimeters and inserted in to the OutMediationStream

kmToft (Function)

Converts the input kilometers into feet

Syntax

<DOUBLE> unitconversion:kmToft(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilometers into feet INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilometreToFootStream (inValue int); 
from UnitConversionForKilometreToFootStream 
select unitconversion:kmToft(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilometer values from UnitConversionForKilometreToFootStream will be converted to feet and inserted in to the OutMediationStream

kmToin (Function)

Converts the input kilometers into inches

Syntax

<DOUBLE> unitconversion:kmToin(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilometers into inches INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilometreToInchStream (inValue int); 
from UnitConversionForKilometreToInchStream 
select unitconversion:kmToin(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilometer values from UnitConversionForKilometreToInchStream will be converted to inches and inserted in to the OutMediationStream

kmTom (Function)

Converts the input kilometers into meters

Syntax

<DOUBLE> unitconversion:kmTom(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilometers into meters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilometreToMetreStream (inValue int); 
from UnitConversionForKilometreToMetreStream 
select unitconversion:kmTom(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilometer values from UnitConversionForKilometreToMetreStream will be converted to meters and inserted in to the OutMediationStream

kmTomi (Function)

Converts the input kilometers into miles

Syntax

<DOUBLE> unitconversion:kmTomi(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilometers into miles INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilometreToMileStream (inValue int); 
from UnitConversionForKilometreToMileStream 
select unitconversion:kmTomi(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilometer values from UnitConversionForKilometreToMileStream will be converted to miles and inserted in to the OutMediationStream

kmTomm (Function)

Converts the input kilometers into millimeters

Syntax

<DOUBLE> unitconversion:kmTomm(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilometers into millimeters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilometreToMillimetreStream (inValue int); 
from UnitConversionForKilometreToMillimetreStream 
select unitconversion:kmTomm(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilometer values from UnitConversionForKilometreToMillimetreStream will be converted to millimeters and inserted in to the OutMediationStream

kmTonm (Function)

Converts the input kilometers into nanometers

Syntax

<DOUBLE> unitconversion:kmTonm(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilometers into nanometers INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilometreToNanometreStream (inValue int); 
from UnitConversionForKilometreToNanometreStream 
select unitconversion:kmTonm(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilometer values from UnitConversionForKilometreToNanometreStream will be converted to nanometers and inserted in to the OutMediationStream

kmToum (Function)

Converts the input kilometers into micrometers

Syntax

<DOUBLE> unitconversion:kmToum(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilometers into micrometers INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilometreToMicrometreStream (inValue int); 
from UnitConversionForKilometreToMicrometreStream 
select unitconversion:kmToum(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilometer values from UnitConversionForKilometreToMicrometreStream will be converted to micrometers and inserted in to the OutMediationStream

kmToyd (Function)

Converts the input kilometers into yards

Syntax

<DOUBLE> unitconversion:kmToyd(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from kilometers into yards INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForKilometreToYardStream (inValue int); 
from UnitConversionForKilometreToYardStream 
select unitconversion:kmToyd(inValue) as UnitConversionValue 
insert into OutMediationStream;

The kilometer values from UnitConversionForKilometreToYardStream will be converted to yards and inserted in to the OutMediationStream

lTom3 (Function)

Converts the input liters into cubic meters

Syntax

<DOUBLE> unitconversion:lTom3(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from liters into cubic meters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForLitreToCubicmetreStream (inValue int); 
from UnitConversionForLitreToCubicmetreStream 
select unitconversion:lTom3(inValue) as UnitConversionValue 
insert into OutMediationStream;

The liter values from UnitConversionForLitreToCubicmetreStream will be converted to cubic meters and inserted in to the OutMediationStream

lToml (Function)

Converts the input liters into milliliters

Syntax

<DOUBLE> unitconversion:lToml(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from liters into milliliters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForLitreToMillilitreStream (inValue int); 
from UnitConversionForLitreToMillilitreStream 
select unitconversion:lToml(inValue) as UnitConversionValue 
insert into OutMediationStream;

The liter values from UnitConversionForLitreToMillilitreStream will be converted to milliliters and inserted in to the OutMediationStream

m3Tol (Function)

Converts the input cubic meters into liters

Syntax

<DOUBLE> unitconversion:m3Tol(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from meters into liters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForCubicmetreToLitreStream (inValue int); 
from UnitConversionForCubicmetreToLitreStream 
select unitconversion:m3Tol(inValue) as UnitConversionValue 
insert into OutMediationStream;

The cubic meter values from UnitConversionForCubicmetreToLitreStream will be converted to liters and inserted in to the OutMediationStream

mTocm (Function)

Converts the input meters into centimeters

Syntax

<DOUBLE> unitconversion:mTocm(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from meters into centimeters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForMetreToCentimetreStream (inValue int); 
from UnitConversionForMetreToCentimetreStream 
select unitconversion:mTocm(inValue) as UnitConversionValue 
insert into OutMediationStream;

The meter values from UnitConversionForMetreToCentimetreStream will be converted to centimeters and inserted in to the OutMediationStream

mToft (Function)

Converts the input meters into feet

Syntax

<DOUBLE> unitconversion:mToft(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from meters into feet INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForMetreToFootStream (inValue int); 
from UnitConversionForMetreToFootStream 
select unitconversion:mToft(inValue) as UnitConversionValue 
insert into OutMediationStream;

The meter values from UnitConversionForMetreToFootStream will be converted to feet and inserted in to the OutMediationStream

mTomm (Function)

Converts the input meters into millimeters

Syntax

<DOUBLE> unitconversion:mTomm(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from meters into millimeters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForMetreToMillimetreStream (inValue int); 
from UnitConversionForMetreToMillimetreStream 
select unitconversion:mTomm(inValue) as UnitConversionValue 
insert into OutMediationStream;

The meter values from UnitConversionForMetreToMillimetreStream will be converted to millimeters and inserted in to the OutMediationStream

mTos (Function)

Converts the input minutes into seconds

Syntax

<DOUBLE> unitconversion:mTos(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from minutes into seconds INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForMinuteToSecondStream (inValue int); 
from UnitConversionForMinuteToSecondStream 
select unitconversion:mTos(inValue) as UnitConversionValue 
insert into OutMediationStream;

The minute values from UnitConversionForMinuteToSecondStream will be converted to seconds and inserted in to the OutMediationStream

mToyd (Function)

Converts the input meters into yards

Syntax

<DOUBLE> unitconversion:mToyd(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from meters into yards INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForMetreToYardStream (inValue int); 
from UnitConversionForMetreToYardStream 
select unitconversion:mToyd(inValue) as UnitConversionValue 
insert into OutMediationStream;

The meter values from UnitConversionForMetreToYardStream will be converted to yards and inserted in to the OutMediationStream

miTokm (Function)

Converts the input miles into kilometers

Syntax

<DOUBLE> unitconversion:miTokm(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from miles into kilometers INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForMileToKilometreStream (inValue int); 
from UnitConversionForMileToKilometreStream 
select unitconversion:miTokm(inValue) as UnitConversionValue 
insert into OutMediationStream;

The mile values from UnitConversionForMileToKilometreStream will be converted to kilometers and inserted in to the OutMediationStream

mlTol (Function)

Converts the input milliliters into liters

Syntax

<DOUBLE> unitconversion:mlTol(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from milliliters into liters INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForMillilitreToLitreStream (inValue int); 
from UnitConversionForMillilitreToLitreStream 
select unitconversion:mlTol(inValue) as UnitConversionValue 
insert into OutMediationStream;

The milliliter values from UnitConversionForMillilitreToLitreStream will be converted to liters and inserted in to the OutMediationStream

sToms (Function)

Converts the input seconds into milliseconds

Syntax

<DOUBLE> unitconversion:sToms(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from seconds into milliseconds INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForSecondToMillisecondStream (inValue int); 
from UnitConversionForSecondToMillisecondStream 
select unitconversion:sToms(inValue) as UnitConversionValue 
insert into OutMediationStream;

The second values from UnitConversionForSecondToMillisecondStream will be converted to milliseconds and inserted in to the OutMediationStream

sTons (Function)

Converts the input seconds into nanoseconds

Syntax

<DOUBLE> unitconversion:sTons(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from seconds into nanoseconds INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForSecondToNanosecondStream (inValue int); 
from UnitConversionForSecondToNanosecondStream 
select unitconversion:sTons(inValue) as UnitConversionValue 
insert into OutMediationStream;

The second values from UnitConversionForSecondToNanosecondStream will be converted to nanoseconds and inserted in to the OutMediationStream

sTous (Function)

Converts the input seconds into microseconds

Syntax

<DOUBLE> unitconversion:sTous(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from seconds into microseconds INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForSecondToMicrosecondStream (inValue int); 
from UnitConversionForSecondToMicrosecondStream 
select unitconversion:sTous(inValue) as UnitConversionValue 
insert into OutMediationStream;

The second values from UnitConversionForSecondToMicrosecondStream will be converted to microseconds and inserted in to the OutMediationStream

tTog (Function)

Converts the input Tonnes into grams

Syntax

<DOUBLE> unitconversion:tTog(<INT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from Tonnes into grams INT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForTonneToGramStream (inValue int); 
from UnitConversionForTonneToGramStream 
select unitconversion:tTog(inValue) as UnitConversionValue 
insert into OutMediationStream;

The Tonne values from UnitConversionForTonneToGramStream will be converted to grams and inserted in to the OutMediationStream

tTokg (Function)

Converts the input Tonnes into kilograms

Syntax

<DOUBLE> unitconversion:tTokg(<INT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from Tonnes into kilograms INT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForTonneToKilogramStream (inValue int); 
from UnitConversionForTonneToKilogramStream 
select unitconversion:tTokg(inValue) as UnitConversionValue 
insert into OutMediationStream;

The Tonne values from UnitConversionForTonneToKilogramStream will be converted to kilograms and inserted in to the OutMediationStream

yTod (Function)

Converts the input years into days

Syntax

<DOUBLE> unitconversion:yTod(<INT|LONG|FLOAT|DOUBLE> p1)

QUERY PARAMETERS

Name Description Default Value Possible Data Types Optional Dynamic
p1 The value needed to be converted from years into days INT
LONG
FLOAT
DOUBLE
No No

Examples EXAMPLE 1

define stream UnitConversionForYearToDayStream (inValue int); 
from UnitConversionForYearToDayStream 
select unitconversion:yTod(inValue) as UnitConversionValue 
insert into OutMediationStream;

The year values from UnitConversionForYearToDayStream will be converted to days and inserted in to the OutMediationStream