Database Management Systems
MariaDB includes a large collection of date and time functions that return a given date in a certain format.
One thing you can do is return the day number with the relevant “st/nd/rd/th” suffix. For example, instead of returning it as say, 10 July 2025, it’s returned as 10th July 2025.
Below is an example of adding the relevant suffix to a day number in MariaDB.
Continue readingBelow are two options for finding those rows that contain alphanumeric characters in MySQL.
Alphanumeric characters are alphabetic characters and numeric characters.
Continue readingIn MariaDB, we can use the GROUP_CONCAT() function to return our query results as a comma separated list. By that I mean, for a given column, we can convert all rows into a single row that contains a comma separated list of the values that made up that column. Each row is a separate item in the list.
Here are four options for returning rows that contain lowercase characters in Oracle Database.
Continue readingHere’s an example of returning rows that contain alphanumeric characters in SQLite.
Alphanumeric characters are alphabetic characters and numeric characters.
Continue readingIn MariaDB, you can use the DATE_FORMAT() function to return the month name and day name from a date.
This function accepts an optional argument that let’s you specify the language that is used for the result.
Continue readingOracle Database includes several views that contain information about triggers in the database. We can use these views to return a list of triggers.
Continue readingHere are four options for returning rows that contain lowercase characters in MariaDB.
Continue readingHere are some options for subtracting one or more hours from a datetime value in MariaDB.
Continue readingThe following examples return only those rows that have numeric values in a given column in Oracle Database.
These examples use the REGEXP_LIKE function to return values that match the specified pattern.