CSC

​

Syntax

​

Scalar

csc(value)

​

Arguments

​

Returns

• Type: DOUBLE
• Possible values: The reciprocal of sine.
• NULL behavior: Returns NULL when an argument is NULL.

​

Properties

• Approximation bound: No fixed maximum error is guaranteed.

​

Units

• Input unit: Radians
• Output unit: Dimensionless ratio
• Use radians(degrees) to convert an angle expressed in degrees.

​

Usage notes

• INTEGER and INT mean the same type; STRING means VARCHAR text. NULL can be used with a supported type. Cast NULL explicitly when its type would otherwise be unclear.
• Exact result: Floating-point computation can round the mathematical result.

​

Examples

​

Value and NULL input

SELECT csc(CAST(0 AS DOUBLE)) AS "value", csc(CAST(NULL AS DOUBLE)) AS null_value;

​

Positive and negative quarter-turns

SELECT round(csc(pi() / 2), 6) AS positive_angle, round(csc(-pi() / 2), 6) AS negative_angle;

​

Limitations

• An input of zero returns positive infinity.