Most of the major RDBMSs have functions that enable us to extract the day, month, and year from datetime values.
Some RDBMSs provide multiple ways to do this, and others are more limited. Below are examples of extracting the day, month, and year from date values in some of the most popular RDBMSs.
Continue readingHere’s a list of units that can be used in MySQL datetime and interval functions.
Continue readingOracle Database has the TO_CHAR(datetime) function that enables us to get various date parts from a datetime value.
There’s also the EXTRACT(datetime) function that extracts a specific datetime unit (e.g. day, month, year, etc).
In SQLite, we can use the strftime() function to return datetime values in our chosen format.
Therefore, we can use it to extract the day, month, and year from a date.
Continue readingPostgreSQL provides us with several ways to get the day, month, and year from a date.
Three functions that immediately come to mind are; DATE_PART(), EXTRACT(), and TO_CHAR().
MySQL has a bunch of different functions that enable us to get various date parts – such as the day, month, and year – from a date.
Continue readingIn MySQL, YEAR() is a built-in date and time function that returns the year from a given date expression.
It returns the year as a number in the range 1000 to 9999. For zero dates, it could return 0 or NULL with a warning, depending on the values in your sql_mode.
Here’s a list of MySQL format specifiers that can be used in format strings with functions like DATE_FORMAT(), STR_TO_DATE(), and UNIX_TIMESTAMP().
Most major RDBMSs provide at least one function that enables us to return the month name from a date.
Continue readingThe following two functions enable us to get the month name from a date in MySQL.
Continue reading