In Oracle Database, the NVL() function allows us to replace null values with another value.
DBMS
Database Management Systems
MariaDB Composite Date & Time Units Explained
MariaDB includes a bunch of date and time units that you can use when working with date and time values. For example, MONTH is a unit, and HOUR is another unit.
Some units are composite units. Composite units are when two units get combined into one. The naming convention is that each unit name is separated by an underscore. For example, MINUTE_SECOND is for minutes and seconds.
Below are some examples that demonstrate how composite units work in MariaDB.
COALESCE() Function in Oracle
In Oracle Database, the COALESCE() function returns the first non-null expression the expression list.
How to Add the AD/BC Indicator to a Date in Oracle
When using the TO_CHAR() function to format a datetime value in Oracle Database, you can add the AD/BC indicator by simply adding either AD or BC to your format model.
Oracle then displays the appropriate indicator, depending on whether the date value is AD or BC.
You can provide it in any uppercase or lowercase, and with or without dots (e.g. AD, A.D. ad, a.d, etc). Oracle will then display the indicator as specified.
2 Functions that Return the Seconds from a Datetime Value in Oracle
Below are two functions that can be used to return the seconds portion from a datetime value in Oracle Database.
How to Format Dates in Oracle
This article contains common examples of formatting dates in Oracle Database.
MariaDB FLOOR() vs TRUNCATE()
MariaDB has a FLOOR() function and a TRUNCATE() function that can return the same results or different results, depending on the exact value of their arguments.
Below is a quick rundown on the difference between FLOOR() and TRUNCATE() in MariaDB.
How to Return the Number of Seconds Past Midnight in Oracle Database
Oracle Database provides the SSSSS format element that enables us to get the number of seconds past midnight from a given datetime value.
MariaDB ROUND() vs TRUNCATE()
MariaDB has a ROUND() function and a TRUNCATE() function that can return the same results or different results, depending on the exact value of their arguments.
As the function names suggest, ROUND() rounds the number and TRUNCATE() truncates the number. Truncating a number simply cuts it off without performing any rounding.
Below is a quick rundown on the difference between ROUND() and TRUNCATE() in MariaDB.
How to Get the Month Name from a Date in Oracle
In Oracle Database, the TO_CHAR(datetime) allows us to return a datetime value, formatted in a way that we specify.
One of the things we can do is return the month name from a date.