Here are six ways to check what version of MariaDB you’re currently running.
Continue readingCategory: DBMS
Database Management Systems
Find Out Which Quarter a Date Belongs to in Oracle
When using the TO_CHAR(datetime) function in Oracle Database, you can use the Q format element to return the quarter that a given date belongs to.
List of Languages Supported by Oracle Database
The following table contains a list of territories that are supported by Oracle Database.
Continue readingWEEKDAY() 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 readingHow to Install Oracle Database on Windows
Below are the steps I used to install Oracle Database 18c XE on Windows 10.
Oracle Database 18c XE is the free Express Edition of Oracle. This is a good entry point into Oracle Database. XE is a regular Oracle Database, and it therefore provides compatibility with other Oracle Database editions. You can always move to another edition if you ever need to.
Continue readingFix: “the leading precision of the interval is too small” in Oracle Database
If you’re trying to use an interval literal in Oracle, but you keep getting the “leading precision of the interval is too small” error, hopefully this helps.
Continue readingHow to Get the Day Name from a Date in Oracle
With Oracle Database, we can use the TO_CHAR(datetime) function to return a datetime value, formatted in a way that we specify.
We can use this function to return the day name from a date (as well as any other parts of the datetime value).
Continue readingBIN_TO_NUM() Function in Oracle
In Oracle Database, the BIT_TO_NUM() function converts a bit vector to its equivalent number.
How to Calculate Age in MariaDB
In MariaDB, you can use the TIMESTAMPDIFF() function to calculate a person’s age (or the age of anything for that matter).
TIMESTAMPDIFF() is a built-in date and time function that returns the difference between two date or datetime expressions. Passing YEAR as the first argument, date of birth as the second argument, and the current date as the third, will return the age in years.
ASCIISTR() Function in Oracle
In Oracle Database, the ASCIISTR() function returns an ASCII version of the given string in the database character set.