Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (153)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,170)
  • SQLite (299)

Tag: mathematical functions

How Cosd() Works in PostgreSQL

Posted on June 21, 2020June 21, 2020 by Ian

In PostgreSQL, cosd() is a mathematical function that returns the trigonometric cosine of the specified angle, as measured in degrees.

You specify the angle by providing an argument to the function when calling it.

Continue reading →
PostgreSQL functions, mathematical functions, what is

How Acos() Works in PostgreSQL

Posted on June 21, 2020June 21, 2020 by Ian

In PostgreSQL, acos() is a mathematical function that returns the inverse cosine of the specified expression, measured in radians.

The inverse cosine is also known as the arccosine.

Continue reading →
PostgreSQL functions, mathematical functions, what is

How Acosd() Works in PostgreSQL

Posted on June 21, 2020June 21, 2020 by Ian

In PostgreSQL, acosd() is a mathematical function that returns the inverse cosine of the specified expression, measured in degrees.

The inverse cosine is also known as the arccosine.

Continue reading →
PostgreSQL functions, mathematical functions, what is

How Log() Works in PostgreSQL

Posted on June 20, 2020June 20, 2020 by Ian

In PostgreSQL, log() is a mathematical function that returns the base 10 logarithm of its argument.

However, it also allows you to optionally specify a base with which to use.

Continue reading →
PostgreSQL functions, mathematical functions, what is

How the Ln() Function Works in PostgreSQL

Posted on June 19, 2020June 19, 2020 by Ian

In PostgreSQL, ln() is a mathematical function that returns the natural logarithm of its argument.

Continue reading →
PostgreSQL functions, mathematical functions, what is

How the Exp() Function Works in PostgreSQL

Posted on June 19, 2020June 19, 2020 by Ian

In PostgreSQL, exp() is a mathematical function that returns the exponential value of its argument.

Continue reading →
PostgreSQL functions, mathematical functions, what is

How Pi() Works in PostgreSQL

Posted on June 17, 2020June 17, 2020 by Ian

In PostgreSQL, the pi() function returns the number π.

Ï€ constant is a mathematical constant. It is defined as the ratio of a circle’s circumference to its diameter.

Continue reading →
PostgreSQL functions, mathematical functions, what is

How the Degrees() Function Works in PostgreSQL

Posted on June 17, 2020June 17, 2020 by Ian

In PostgreSQL, the degrees() function converts from radians to degrees.

The radian is the SI (International System of Units) unit for measuring angles. One radian is just under 57.3 degrees, and a full circle has just over 6.28 radians (2Ï€).

Continue reading →
PostgreSQL functions, mathematical functions, what is

How the Radians() Function Works in PostgreSQL

Posted on June 17, 2020June 17, 2020 by Ian

In PostgreSQL, the radians() function converts from degrees to radians.

The radian is the SI (International System of Units) unit for measuring angles. One radian is just under 57.3 degrees, and a full circle has just over 6.28 radians (2Ï€).

Continue reading →
PostgreSQL functions, mathematical functions, what is

How Trunc() Works in PostgreSQL

Posted on June 17, 2020June 17, 2020 by Ian

In PostgreSQL, the trunc() function truncates a number.

More specifically, it truncates the number either toward zero, or to a specific number of decimal places.

Continue reading →
PostgreSQL functions, mathematical functions, what is
  • «
  • 1
  • …
  • 6
  • 7
  • 8
  • 9
  • 10
  • …
  • 14
  • »

About Database.Guide | Privacy Policy