In Oracle Database, the SESSIONTIMEZONE function returns the time zone of the current session.
Tag: what is
DBTIMEZONE Function in Oracle
In Oracle Database, the DBTIMEZONE function returns the value of the database time zone.
ADD_MONTHS() Function in Oracle
In Oracle Database, the ADD_MONTHS() function adds a given number of months to a date, and returns the result.
CURRENT_DATE Function in Oracle
In Oracle Database, the CURRENT_DATE function returns the current date in the session time zone, in a value in the Gregorian calendar of data type DATE.
CURRENT_TIMESTAMP() Function in Oracle
In Oracle Database, the CURRENT_TIMESTAMP() function returns the current date and time in the session time zone, in a value of data type TIMESTAMP WITH TIME ZONE.
It’s similar to LOCALTIMESTAMP, except that LOCALTIMESTAMP returns a TIMESTAMP value.
LOCALTIMESTAMP() Function in Oracle
In Oracle Database, the LOCALTIMESTAMP() function returns the current date and time in the session time zone in a value of data type TIMESTAMP.
It’s similar to CURRENT_TIMESTAMP, except that CURRENT_TIMESTAMP returns a TIMESTAMP WITH TIME ZONE value.
SYSTIMESTAMP Function in Oracle
In Oracle Database, the SYSTIMESTAMP function returns the system date, including fractional seconds and time zone, of the system on which the database resides.
The returned value is of type TIMESTAMP WITH TIME ZONE.
SYSDATE Function in Oracle
In Oracle Database, the SYSDATE function returns the current date and time set for the operating system on which the database server resides.
The returned value is of type DATE.
EXTRACT (datetime) Function in Oracle
In Oracle Database, the EXTRACT(datetime) function extracts and returns the value of a specified datetime field from a datetime or interval expression.
TRANSLATE(… USING) Function in Oracle
In Oracle, the TRANSLATE(...USING) function converts its argument into the character set specified for conversions between the database character set and the national character set.
This function is not to be confused with the TRANSLATE() function, which allows you to make several single-character, one-to-one substitutions in one operation.
The TRANSLATE(...USING) function is supported in Oracle primarily for ANSI compatibility. Oracle recommends that we use the TO_CHAR() and TO_NCHAR() functions instead.