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.
GREATEST() Function in Oracle
In Oracle Database, the GREATEST() function returns the greatest of a list of one or more expressions.
LEAST() Function in Oracle
In Oracle Database, the LEAST() function returns the least of a list of one or more expressions.
Supported Format Models for the ROUND() and TRUNC() Date Functions in Oracle
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.
TO_TIMESTAMP() Function in Oracle
In Oracle Database, the TO_TIMESTAMP() function converts its argument to a value of TIMESTAMP data type.
TO_TIMESTAMP_TZ() Function in Oracle
In Oracle Database, the TO_TIMESTAMP_TZ() function converts its argument to a value of TIMESTAMP WITH TIME ZONE data type.
2 Functions to Get the Year from a Date in Oracle
Below are two functions that can be used to extract the year from a date in Oracle Database.
Continue readingTO_DSINTERVAL() Function in Oracle
In Oracle Database, the TO_DSINTERVAL() function converts its argument to a value of INTERVAL DAY TO SECOND data type.
TZ_OFFSET() Function in Oracle
In Oracle Database, the TZ_OFFSET() function returns the time zone offset corresponding to the argument based on the date the statement is executed.
NUMTOYMINTERVAL() Function in Oracle
In Oracle Database, the NUMTOYMINTERVAL() function converts a number to an INTERVAL YEAR TO MONTH literal.