MariaDB has an RTRIM() function and a RTRIM_ORACLE() function. Both functions do essentially the same thing. But there is a minor difference.
Tag: functions
TO_CHAR(number) Function in Oracle
In Oracle Database, the TO_CHAR(number) function converts a number to a VARCHAR2 value in the format specified by the format argument.
WEEKDAY() vs DAYOFWEEK() in MariaDB: What’s the Difference?
MariaDB provides a WEEKDAY() function and a DAYOFWEEK() function, both of which return the day of the week, represented as a number.
But the number returned is different between these functions.
This post looks at the difference.
Continue readingBIN_TO_NUM() Function in Oracle
In Oracle Database, the BIT_TO_NUM() function converts a bit vector to its equivalent number.
ASCIISTR() Function in Oracle
In Oracle Database, the ASCIISTR() function returns an ASCII version of the given string in the database character set.
TRUNC(date) Function in Oracle
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.
TO_YMINTERVAL() Function in Oracle
In Oracle Database, the TO_YMINTERVAL() function converts its argument to a value of INTERVAL MONTH TO YEAR data type.
SYS_EXTRACT_UTC() Function in Oracle
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.