Skip to content

ST_Rotate

Rotates a geometry counter-clockwise around the Z axis by an angle in radians.

Usage

geometry ST_Rotate(geom: geometry, rot: double)

Arguments

  • geom (geometry): Input geometry
  • rot (double)

Examples

SELECT ST_Rotate(ST_GeomFromText('POINT (1 0)'), radians(90));
┌────────────────────────────────────────────────────────────────────┐
│ st_rotate(st_geomfromtext(Utf8("POINT (1 0)")),radians(Int64(90))) │
│                              geometry                              │
╞════════════════════════════════════════════════════════════════════╡
│ POINT(0.00000000000000006123233995736766 1)                        │
└────────────────────────────────────────────────────────────────────┘