OracleNumeric FunctionsTRUNC
ROUND

TRUNCNumeric Functions

MOD

Truncates to d decimal places.

Syntax

TRUNC(n [, d])

Example

Enter values below to update the example in real time.

first_day_of_month
SELECT TRUNC(SYSDATE, 'MM') AS first_day_of_month FROM DUAL;