Skip to content

Database.Guide

DBMS

Database Management Systems

How Sind() Works in PostgreSQL

June 22, 2020 by Ian

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

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

In trigonometry, sine is the function that is equal to the ratio of the side opposite a given angle (in a right-angled triangle) to the hypotenuse.

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Cos() Works in PostgreSQL

June 21, 2020 by Ian

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

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

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Cosd() Works in PostgreSQL

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

Read more

Categories PostgreSQL Tags functions, mathematical functions, what is

How Acos() Works in PostgreSQL

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

Read more

Categories PostgreSQL Tags functions, mathematical functions, 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

Get the Century from a Date in PostgreSQL

January 28, 2021June 19, 2020 by Ian

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.

Read more

Categories PostgreSQL Tags date format, dates, how to

How to Create Ordinal Numbers in PostgreSQL

June 18, 2020 by Ian

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.

Read more

Categories PostgreSQL Tags how to, number format
Older posts
Newer posts
← Previous Page1 … Page297 Page298 Page299 … Page391 Next →

About | Privacy Policy

© 2026 Database.Guide • All rights reserved