For similar capabilities to Amazon Timestream for LiveAnalytics, consider Amazon Timestream for InfluxDB. It offers simplified data ingestion and single-digit millisecond query response times for real-time analytics. Learn more [here](https://docs.aws.amazon.com//timestream/latest/developerguide/timestream-for-influxdb.html).

# Mathematical functions
<a name="mathematical-functions"></a>

Timestream for LiveAnalytics supports the following mathematical functions.


| Function | Output data type | Description | 
| --- | --- | --- | 
|  abs(x)  |  [same as input]  |  Returns the absolute value of x.  | 
|  cbrt(x)  |  double  |  Returns the cube root of x.  | 
|  ceiling(x) or ceil(x)  |  [same as input]  |  Returns x rounded up to the nearest integer.  | 
|  degrees(x)  |  double  |  Converts angle x in radians to degrees.  | 
|  e()  |  double  |  Returns the constant Euler's number.  | 
|  exp(x)  |  double  |  Returns Euler's number raised to the power of x.  | 
|  floor(x)  |  [same as input]  |  Returns x rounded down to the nearest integer.  | 
|  from\$1base(string,radix)  |  bigint  |  Returns the value of string interpreted as a base-radix number.  | 
|  ln(x)  |  double  |  Returns the natural logarithm of x.  | 
|  log2(x)  |  double  |  Returns the base 2 logarithm of x.  | 
|  log10(x)  |  double  |  Returns the base 10 logarithm of x.  | 
|  mod(n,m)   |  [same as input]  |  Returns the modulus (remainder) of n divided by m.  | 
|  pi()   |  double  |  Returns the constant Pi.  | 
|  pow(x, p) or power(x, p)  |  double  |  Returns x raised to the power of p.  | 
|  radians(x)  |  double  |  Converts angle x in degrees to radians.  | 
|  rand() or random()  |  double  |  Returns a pseudo-random value in the range 0.0 1.0.  | 
|  random(n)  |  [same as input]  |  Returns a pseudo-random number between 0 and n (exclusive).  | 
|  round(x)  |  [same as input]  |  Returns x rounded to the nearest integer.  | 
|  round(x,d)  |  [same as input]  |  Returns x rounded to d decimal places.  | 
|  sign(x)  |  [same as input]  |  Returns the signum function of x, that is: [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/timestream/latest/developerguide/mathematical-functions.html) For double arguments, the function additionally returns: [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/timestream/latest/developerguide/mathematical-functions.html)  | 
|  sqrt(x)   |  double  |  Returns the square root of x.  | 
|  to\$1base(x, radix)   |  varchar  |  Returns the base-radix representation of x.  | 
|  truncate(x)   |  double  |  Returns x rounded to integer by dropping digits after decimal point.  | 
|  acos(x)  |  double  |  Returns the arc cosine of x.  | 
|  asin(x)   |  double  |  Returns the arc sine of x.  | 
|  atan(x)   |  double  |  Returns the arc tangent of x.  | 
|  atan2(y, x)  |  double  |  Returns the arc tangent of y / x.  | 
|  cos(x)  |  double  |  Returns the cosine of x.  | 
|  cosh(x)  |  double  |  Returns the hyperbolic cosine of x.  | 
|  sin(x)   |  double  |  Returns the sine of x.  | 
|  tan(x)  |  double  |  Returns the tangent of x.  | 
|  tanh(x)  |  double  |  Returns the hyperbolic tangent of x.  | 
|  infinity()  |  double  |  Returns the constant representing positive infinity.  | 
|  is\$1finite(x)  |  boolean  |  Determine if x is finite.  | 
|  is\$1infinite(x)  |  boolean  |  Determine if x is infinite.  | 
|  is\$1nan(x)  |  boolean  |  Determine if x is not-a-number.  | 
|  nan()  |  double  |  Returns the constant representing not-a-number.  |