Below are 4 functions that enable you to return the year from a date in MariaDB. Three functions return just the year, and one returns both the year and week.
Continue readingTag: dates
How to Run SHOW LOCALES in MariaDB
If you’re trying to run SHOW LOCALES but it’s not working, it’s probably because the LOCALES plugin hasn’t been installed yet. Installing that plugin should hopefully fix the problem.
Get the Day of the Year from a Date in SQL Server (T-SQL)
TSQL provides the DATEPART() function, which enables us to return the day of the year for a given date in SQL Server.
By “day of the year”, I mean the day number of the given year.
Continue reading4 Functions that Extract Microseconds from a Time Value in MariaDB
Below are 4 functions that enable you to return the microseconds part from a time value in MariaDB.
Continue reading3 Ways to Get the Day Name from a Date in MariaDB
Below are three approaches you can use to get the day name from a date in MariaDB.
Two of these approaches return the full day name, and one returns the short day name.
Continue readingFix: “Unknown table ‘locales’ in information_schema” in MariaDB
If you get the Unknown table 'locales' in information_schema error in MariaDB, it’s probably because you haven’t installed the LOCALES plugin yet.
You need to install the LOCALES plugin before you try to query this table.
11 Functions to Get the Day, Month, and Year from a Date in MariaDB
MariaDB includes many functions for working with dates. Some of these extract certain parts from such dates and return them as a string or integer.
Below are 11 functions that you can use to return various date parts in MariaDB.
Continue reading8 Ways to Add Microseconds to a Datetime Value in MariaDB
If you need to add one or more microseconds to a datetime value in MariaDB, here are 8 options to consider.
Continue reading3 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.