Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

Returns the square root of a numeric expression.

Syntax

SQRT(<value>);

Parameters

ParameterDescriptionSupported input types
<value>Value that the SQRT function is applied toDOUBLE PRECISION

Notes

  • When input value is integer data type, it is implicitly converted to DOUBLE PRECISION.
  • When input value is NUMERIC, the SQRT function returns an error.
  • When input value is negative, the SQRT function returns an error.

Return Types

DOUBLE PRECISION.

Example

The following example returns the square root of 64: