Most major RDBMSs provide at least one function that enables us to return the month name from a date.
Continue readingCategory: MariaDB
The Difference Between INSTR() vs LOCATE() in MariaDB
MariaDB has an INSTR() function and also a LOCATE() function. Both functions appear to do exactly the same thing – return the position of a substring within a string.
However, there is a difference.
Continue reading2 Ways to Replace a Substring in MariaDB
If you need to replace a substring with another string in MariaDB, here are two approaches that you can use.
Continue readingDifference Between SYSDATE() and NOW() in MariaDB
In MariaDB, the SYSDATE() and NOW() functions are similar in that they return the current date and time.
However, there is an important difference: SYSDATE() returns the time that it executes, whereas NOW() returns the time that the statement started executing.
And when run within a stored procedure or trigger, SYSDATE() will return the time that it executes, whereas NOW() will return the time that the stored procedure or trigger started executing.
4 Ways to Separate Hours, Minutes, and Seconds from a Time Value in MariaDB
MariaDB has several functions that enable you to extract various date and time parts from date/time values. You can use these to separate each date/time component into its own column if required.
Below are four ways to extract the hours, minutes, and seconds from a time value in MariaDB. As a bonus, we’ll also include microseconds.
Continue readingMariaDB 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.
Continue readingMariaDB 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.
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.
MariaDB ROUND() vs FLOOR()
MariaDB has a ROUND() function and a FLOOR() function that are similar in some ways, but quite different in other ways.
Below is a quick rundown on the difference between ROUND() and FLOOR() in MariaDB.
How to Get the Short Month Name from a Date in MariaDB
In MariaDB, you can use the DATE_FORMAT() function to return various date parts from a date. One of the things you can return is the short month name. For example Nov or Dec (instead of November or December).