Skip to content

Database.Guide

what is

How Acosd() Works in PostgreSQL

June 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.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Log() Works in PostgreSQL

June 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.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How the Ln() Function Works in PostgreSQL

June 19, 2020 by Ian

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

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How the Exp() Function Works in PostgreSQL

June 19, 2020 by Ian

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

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Pi() Works in PostgreSQL

June 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.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How the Degrees() Function Works in PostgreSQL

June 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π).

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How the Radians() Function Works in PostgreSQL

June 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π).

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Trunc() Works in PostgreSQL

June 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.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Ceiling() Works in PostgreSQL

June 15, 2020June 15, 2020 by Ian

In PostgreSQL, the ceiling() function is used for rounding a number up to the nearest integer.

It’s similar to round(), except that it only rounds up. The round() function will round up or down as required.

It’s also similar to floor(), except that floor() rounds down instead of up.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Floor() Works in PostgreSQL

June 15, 2020June 15, 2020 by Ian

In PostgreSQL, the floor() function is used for rounding a number down to the nearest integer.

It’s basically the opposite of ceiling(), which rounds a number up.

It’s also similar to round(), except that it only rounds down. The round() function will round up or down as required.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is
Older posts
Newer posts
← Previous Page1 … Page157 Page158 Page159 … Page166 Next →

About | Privacy Policy

© 2026 Database.Guide • All rights reserved