The TRUNC (date) function returns date with the time portion of the day truncated to the unit specified by the format model fmt. This function is not sensitive to the NLS_CALENDAR session parameter. It …

This tutorial shows you how to use Oracle TRUNC () function to truncate a date to a specified unit and gives you some practical examples.

TRUNC and INT are somewhat similar functions in that they both return integers. TRUNC simply removes the fractional part of the number, whereas INT returns the nearest lower integer (not …

This Oracle tutorial explains how to use the Oracle / PLSQL TRUNC function (as it applies to date values) with syntax and examples. The Oracle / PLSQL TRUNC function returns a date truncated to …

The TRUNC (datetime) function returns date with the time portion of the day truncated to the unit specified by the format model fmt. This function is not sensitive to the NLS_CALENDAR session …

The TRUNC (number) function returns n1 truncated to n2 decimal places. If n2 is omitted, then n1 is truncated to 0 places. n2 can be negative to truncate (make zero) n2 digits left of the decimal point.

When you specify a date and time value as an argument, the TRUNC function returns the date and time value truncated to a specified date format. When you do not specify a format, the date and time …

May 23, 2024 · FE_INEXACT may be (but isn't required to be) raised when truncating a non-integer finite value.

Mar 26, 2015 · The TRUNC function is one of the most common and versatile functions in Oracle. Let's take a look at how it's used and some examples.

Jul 12, 2025 · The TRUNC function is an inbuilt function in PLSQL which is used to return a number truncated to a particular number of decimal places. Syntax: number - This is the input number which …