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 readingTag: date format
How to Get the Short Month Name from a Date in MySQL
In MySQL, you can use the DATE_FORMAT() function with the %b format specifier to return the short month name. For example, you can return Jan or Feb instead of January or February.
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().
Get the Month Name from a Date in SQL
Most major RDBMSs provide at least one function that enables us to return the month name from a date.
Continue reading2 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.
Continue readingReturn 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.
Continue readingCapitalization of Day and Month Names When Formatting Dates in Oracle
When getting the day and/or month name from a date in Oracle, you may want to return it in uppercase, lowercase, or title case.
Fortunately, this is easy to do. The result reflects the capitalisation of your format model.
Continue readingReturn the Short Month 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 month name.
The short month name is also referred to as the abbreviated month name. Examples of returning the short month name are below.
Continue readingHow to Return Fractional Seconds from a Datetime Value in Oracle
When using Oracle Database, you can use the TO_CHAR(datetime) function to return various parts of a datetime value, including the fractional seconds.
To return the fractional seconds part from a datetime value, use the FF format element.
MariaDB 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 reading