PI()

Overview

Returns an approximate value of pi.

See also: Functions for MariaDB Xpand 23.09, in 6.1, in 6.0, and in 5.3

See also: Functions for MariaDB Xpand 6.0 and in 5.3

See also: Functions for MariaDB Xpand 6.1

USAGE

PI()

DETAILS

PI() is a mathematical function that returns the approximate value of pi.

The value is accurate to 12 decimal places.

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

SELECT FORMAT(PI(), 20);

+------------------------+
| FORMAT(PI(), 20)       |
+------------------------+
| 3.14159265358980000000 |
+------------------------+

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.09

  • Present starting in MariaDB Xpand 23.09.1.

6.1

  • Present starting in MariaDB Xpand 6.1.0.

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.1

  • Present starting in MariaDB Xpand 6.1.0.

EXTERNAL REFERENCES