OracleDate/Time FunctionsROUND
NEXT_DAY

ROUNDDate/Time Functions

TRUNC

Rounds a date to the specified unit.

Syntax

ROUND(date [, fmt])

Example

Enter values below to update the example in real time.

salary
avg_salary_k
employees
SELECT ROUND(AVG(salary), -3) AS avg_salary_k
FROM employees;