If you need to add one or more microseconds to a datetime value in MariaDB, here are 8 options to consider.
Continue readingTag: dates
3 Ways to Convert a Date to a String in MongoDB
MongoDB has a Date BSON type that allows you to store dates as dates.
You can also store dates as strings, if that’s what you need.
Taking it a step further, you can also convert a Date to a string.
This article presents three ways to convert a Date to a string in MongoDB.
Continue readingConvert a Month Name to the Month Number in SQL Server (T-SQL)
In SQL Server, you can use the MONTH() function to convert a month name to its corresponding number.
3 Ways to Extract the Year from a Date in SQL Server (T-SQL)
There are several ways to return the year from a date in SQL Server. Here are three (or is it four?).
Continue reading8 Ways to Add Seconds to a Datetime Value in MariaDB
If you need to add one or more seconds to a datetime value in MariaDB, here are 8 options to consider.
Continue reading3 Ways to Get the Month Name from a Date in MariaDB
Here are three ways to return the month name from a date in MariaDB.
Continue readingSubtract a Month from a Date in MariaDB
MariaDB provides several ways to perform arithmetic on dates. This includes adding or subtracting a month (or many months) from a given date.
Here’s an example of subtracting a month from a date in MariaDB.
Continue readingHow MONTHNAME() Works in MariaDB
In MariaDB, MONTHNAME() is a built-in date and time function that returns the name of the month name for a given date.
It accepts one argument, which is the date you want to extract the month name from.
Continue reading6 Ways to Add a Month to a Date in MariaDB
MariaDB provides several ways to perform arithmetic on dates. This includes adding or subtracting a month (or many months) from a given date.
Here are 6 ways to add a month to a date in MariaDB.
Bonus update: I’ve now added a 7th way to add a month to a date at the end of this article. So I guess it’s now 7 ways to add a month to a date in MariaDB 🙂
Continue readingReturn the Language used for Date & Time Functions in MariaDB
MariaDB has a lc_time_names system variable that controls the language used by the DAYNAME(), MONTHNAME() and DATE_FORMAT() date and time functions.
Here’s how to return the value of that variable.
Continue reading