In Oracle Database, the TRUNC(date) function returns the given date value with the time portion of the day truncated to the unit provided in the specified format model.
Oracle also has a TRUNC(number) syntax, which is used on numbers. This article is solely about the TRUNC(date) syntax, which is used on dates.
In Oracle Database, the TO_YMINTERVAL() function converts its argument to a value of INTERVAL MONTH TO YEAR data type.
In Oracle Database, the SYS_EXTRACT_UTC() function extracts the UTC (Coordinated Universal Time) from a datetime value with time zone offset or time zone region name.
In Oracle Database, the TO_TIMESTAMP() function converts its argument to a value of TIMESTAMP data type.
In Oracle Database, the TO_TIMESTAMP_TZ() function converts its argument to a value of TIMESTAMP WITH TIME ZONE data type.
In Oracle Database, the TO_DSINTERVAL() function converts its argument to a value of INTERVAL DAY TO SECOND data type.
In Oracle Database, the TZ_OFFSET() function returns the time zone offset corresponding to the argument based on the date the statement is executed.
In Oracle Database, the NUMTOYMINTERVAL() function converts a number to an INTERVAL YEAR TO MONTH literal.
In Oracle Database, the NUMTODSINTERVAL() function converts a number to an INTERVAL DAY TO SECOND literal.
In Oracle Database, the NEXT_DAY() function returns the date of the first instance of the specified weekday that is later than the specified date.