Database Management Systems
In Oracle Database, when using the TO_CHAR() function to return the day name from a date, padding will be appended to the day name if it’s shorter than the longest valid day name for the given language and calendar.
Well, that’s the default behaviour. However, you can change this if you wish.
To suppress this padding, all you need to do is prepend the day name format element with fm.
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 reading