Skip to main content

gTokg (Function)

This converts the input given in grams into kilograms.

Syntax

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

Query Parameters

NameDescriptionDefault ValuePossible Data TypesOptionalDynamic
p1The value that needs to be converted from grams into kilograms.INT LONG FLOAT DOUBLENoYes

Example 1

unitconversion:gTokg(1000)

In this example, the unitconversion:gTokg() function converts a value of 1000 grams into its equivalent value in kilograms. The conversion result is 1.0 kilograms.

Example 2

CREATE STREAM InputStream (weight_grams double);
CREATE SINK STREAM OutputStream (weight_grams double, weight_kilograms double);

@info(name = 'weightConversionQuery')
INSERT INTO OutputStream
SELECT weight_grams, unitconversion:gTokg(weight_grams) AS weight_kilograms
FROM InputStream;

In this example, an input stream called InputStream is created with a single attribute, weight_grams, representing weights in grams. Then, an output stream called OutputStream is defined, which will contain the original weight in grams as well as the converted weight in kilograms.

The weightConversionQuery processes events from the InputStream. It uses the unitconversion:gTokg() function to convert the weight_grams attribute from the InputStream into its corresponding value in kilograms, and this value is assigned to the weight_kilograms attribute in the OutputStream.

The query outputs the original weight in grams and the converted weight in kilograms for each event to the OutputStream.