Term: TRUNC

Definition:
The TRUNC function truncates either a number or a datetime value. The syntax of the TRUNC function is different depending on the whether it is being used for a number or a date and time value.

TRUNC (datetime)
The TRUNCATE (datetime) function returns date with the time portion of the day truncated to the unit specified by the format model.

TRUNC(datetime_exp, [fmt]);

The [fmt] parameter is the format that indicates how the date and time number should be truncated. If you omit fmt, then date is truncated to the nearest day.

TRUNC(number)
When you specify a number as an argument, the TRUNCATE function truncates a number to a specified number of decimal places.

TRUNC (number, tvalue)

tvalue is an integer value that specifies the number of places to the right or left of the decimal point to which the number should be truncated. When the tvalue parameter is positive, digits to the right of the decimal point are truncated. When tvalue is negative the digits to the left of the decimal point are truncated. When the tvalue parameter is omitted, number is truncated to 0 decimal places.

Related Links:

Oracle Date Functions: TRUNCATE

Related Code Snippets:

Number Functions: Truncate - truncate toward zero
Number Functions: Truncate to n - truncate to n decimal places
Date Functions: TRUNC (date) - The trunc function returns a date truncated to a specific unit of m...
Date Functions: TRUNC - Convert a date to the date it would be at midnight. Using the option w...
TIMESTAMP: TRUNC - The trunc function returns a date truncated to a specific unit of measure.