sToms (Function)
This converts the input given in 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 that needs to be converted from seconds into milliseconds. | INT LONG FLOAT DOUBLE | No | Yes |
Example 1
SELECT unitconversion:sToms(1) AS milliseconds;
This query uses the unitconversion:sToms()
function to convert the value of 1
second into its equivalent value in milliseconds. The conversion result is 1000.0
milliseconds.
Example 2
CREATE STREAM InputStream (time_s double);
CREATE SINK STREAM OutputStream (time_s double, time_ms double);
@info(name = 'timeConversionQuery')
INSERT INTO OutputStream
SELECT time_s, unitconversion:sToms(time_s) AS time_ms
FROM InputStream;
In this example, an input stream called InputStream
is created with a single attribute, time_s
, representing time values in seconds. Then, an output stream called OutputStream
is defined, which will contain the original time in seconds as well as the converted time in milliseconds.
The timeConversionQuery
processes events from the InputStream
. It uses the unitconversion:sToms()
function to convert the time_s
attribute from the InputStream
into its corresponding value in milliseconds, and this value is assigned to the time_ms
attribute in the OutputStream
.
The query outputs the original time in seconds and the converted time in milliseconds for each event to the OutputStream
.