In PostgreSQL, the MOD() function is used to calculate the remainder of a division operation between two numeric values. It returns the remainder after dividing the first argument by the second argument. The basic syntax of the MOD() function is as shown below: MOD(dividend, divisor) In the above syntax, dividend is the numeric value that…

In PostgreSQL, the TRUNC() function is used to truncate a numeric value to a specified number of decimal places or to remove the decimal part completely. Unlike ROUND(), which rounds the number, TRUNC() simply truncates or cuts off the decimal part without any rounding. The basic syntax of the TRUNC() function is as below: TRUNC(numeric_expression…

In PostgreSQL, the ROUND() function is used to round a numeric value to a specified number of decimal places or to the nearest integer. It allows you to round numbers based on your desired precision. The basic syntax of the ROUND() function is as below: ROUND(numeric_expression [, decimal_places]) where numeric_expression is the numeric value or…

In PostgreSQL, the FLOOR() function is used to round a numeric value down to the nearest integer that is less than or equal to the original value. The basic syntax of the FLOOR() function is as follows: FLOOR(numeric_expression) where numeric_expression is the numeric value or expression that you want to round down to the nearest…

In PostgreSQL, the CEIL() function is used to round a numeric value up to the nearest integer that is greater than or equal to the original value. It is also known as the “ceiling” function. The basic syntax of the CEIL() function is as follows: CEIL(numeric_expression) where numeric_expression is the numeric value or expression that…

In PostgreSQL, the ABS() function is used to compute the absolute value of a numeric or interval expression. The absolute value of a number is its magnitude without regard to its sign. If the number is positive or zero, the absolute value remains the same. If the number is negative, the absolute value is its…