Here’s a list of units that can be used in MySQL datetime and interval functions.
dates
2 Functions that Get the Day, Month, and Year from a Date in Oracle
Oracle 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).
How to Extract the Day, Month, and Year from a Date in SQLite
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.
3 Functions that Get the Day, Month, and Year from a Date in PostgreSQL
PostgreSQL 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().
List of MySQL Date Format Specifiers
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().
2 Functions that Return the Month Name from a Date in MySQL
The following two functions enable us to get the month name from a date in MySQL.
Return the Short Day Name from a Date in Oracle
In Oracle Database, we can use the TO_CHAR(datetime) function to return the various date parts from a datetime value, including the short day name.
The short day name is also referred to as the abbreviated day name. In any case, below are examples of returning the short day name from a date value in Oracle.