Skip to main content

sec function

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

SQL
> SELECT sec(pi());
-1.0

> SELECT sec(0);
1.0