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 readingHow Acos() Works in PostgreSQL
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 readingHow Acosd() Works in PostgreSQL
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 readingHow Log() Works in PostgreSQL
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 readingHow the Ln() Function Works in PostgreSQL
In PostgreSQL, ln() is a mathematical function that returns the natural logarithm of its argument.
How the Exp() Function Works in PostgreSQL
In PostgreSQL, exp() is a mathematical function that returns the exponential value of its argument.
Get the Century from a Date in PostgreSQL
In Postgres, you can use the to_char() function to return the century, based on a given date.
To do this, use CC as the second argument. This returns the two-digit century based on the date provided.
How to Create Ordinal Numbers in PostgreSQL
In PostgreSQL, you can use the to_char() function to output numbers in a given format. This includes appending the number with the ordinal indicator.
For example 1, 2, 3 becomes 1st, 2nd, 3rd.
Continue readingHow Pi() Works in PostgreSQL
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 readingHow the Degrees() Function Works in PostgreSQL
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