PostgreSQLNumeric FunctionsPOWER
MOD

POWERNumeric Functions

SQRT

Returns x raised to the power of y.

Syntax

POWER(x, y)

Example

Enter values below to update the example in real time.

deposit
rate
years
future_value
savings
SELECT deposit, ROUND((deposit * POWER(1 + rate, years))::numeric, 0) AS future_value
FROM savings;