sec function

  • Article

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.1

Returns the secant of expr.

Syntax

sec(expr)

Arguments

  • expr: An expression that evaluates to a numeric expressing the angle in radians.

Returns

A DOUBLE.

sec(expr) is equivalent to 1 / cos(expr)

Examples

> SELECT sec(pi());
 -1.0

> SELECT sec(0);
 1.0