SIN
Returns the sine of an angle given in radians.
PostgreSQL 17.9
SIN(angle)- angle
- Angle in radiansdouble precision
Return value
A floating-point number (double precision) from -1 to 1
Examples
Sine of a right angle
PostgreSQL 17.9
SELECT SIN(PI() / 2);Angle in radians and in degrees
PostgreSQL 17.9
SELECT SIN(RADIANS(30)) AS from_radians,
SIND(30) AS from_degrees;Details
For an angle in degrees, use SIND.
SIN(PI()) gives about 1e-16, not exactly 0.