Database Management Systems
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 GREATEST() function returns the greatest of a list of one or more expressions.
In Oracle Database, the LEAST() function returns the least of a list of one or more expressions.
Below is a full list of the format models that are available to be used with the ROUND(date) and TRUNC(date) functions in Oracle Database.
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.
Below are two functions that can be used to extract the year from a date in Oracle Database.
In Oracle Database, the TO_DSINTERVAL() function converts its argument to a value of INTERVAL DAY TO SECOND data type.