date functions

In MySQL, the FROM_DAYS() function returns a date value based on the number of days provided as an argument.

This article contains examples to demonstrate.

Read more

In MySQL, you can use the EXTRACT() function to extract parts from a date. For example, you can extract the year part, the month part, or the day part, etc. You can also extract parts from the time component, such as minutes, seconds, microseconds, etc.

This article contains examples to demonstrate.

Read more

When running queries in MySQL, you can use the DAYOFYEAR() function to return the day of the year from a date.

This function accepts one argument, and it returns a value between 1 and 366, depending on which day of the year the day part of the argument represents.

Read more

You can use the DAYOFWEEK() function in MySQL to return the day of the week from a date.

In this context, a return value of 1 corresponds to Sunday, 2 corresponds to Monday, etc.

This article contains examples to demonstrate.

Read more

You can use the DAYNAME() function in MySQL to return the weekday name from a date.

By “weekday name”, I mean a value like Monday or Sunday. For example, if you provide a date of 2018-01-07, the DAYNAME() function will return Sunday.

Read more

In MySQL, the DAY() function is a synonym for the DAYOFMONTH() function. It’s used to return the day of the month from a date.

In this context the “day of the month” is a value between 1 and 31, or 0 for dates with a zero day part. For example, if you provide a date of 2020-05-03, the DAY() function will return 3.

Read more

You can use the DAYOFMONTH() function in MySQL to return the day of the month from a date.

By “day of the month”, I mean a value between 1 and 31 (or 0 for dates with a zero day part), as opposed to the day of the week, such as Monday etc.

For example, if you provide a date of 2018-01-07, the DAYOFMONTH() function will return 7.

Read more

This article contains examples of the DATE_FORMAT() function in MySQL.

The DATE_FORMAT() function allows you to return a date in a specified format. For example, you can use it to return  2020-06-18 as Thursday, June 2020, or whatever other format you require.

Read more

In MySQL, you can use the DATEDIFF() function to find the difference between two dates. The way it works is, you provide two arguments (one for each date), and DATEDIFF() will return the number of days between the two dates.

Examples below.

Read more

When using MySQL, you can use the DATE() function to extract the date part from a date or datetime expression.

Here’s how it works.

Read more