In Oracle, the NLS_CHARSET_ID() function returns the character set ID number of a given character set. You pass the character set name as an argument, and it returns its ID.
Tag: what is
MariaDB JSON_VALUE() vs JSON_QUERY(): What’s the Difference?
In MariaDB, the JSON_VALUE() function and JSON_QUERY() function do similar things – they return data from a JSON document.
So what’s the difference?
The main difference is that JSON_VALUE() returns scalar values, whereas JSON_QUERY() returns arrays and objects.
FROM_TZ() Function in Oracle
In Oracle Database, the FROM_TZ() function converts a timestamp value and a time zone to a TIMESTAMP WITH TIME ZONE value.
You pass the timestamp value and the time zone as two separate arguments, and the function returns them as a TIMESTAMP WITH TIME ZONE value.
SESSIONTIMEZONE Function in Oracle
In Oracle Database, the SESSIONTIMEZONE function returns the time zone of the current session.
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.