dates

In MySQL, you can use the SUBTIME() function to subtract a time value from a time or datetime expression.

The way it works is, you provide two arguments; the first is a time or datetime value, and the second is a time value. The SUBTIME() function then subtracts the second argument from the first one and returns the result.

Read more

In MySQL, the QUARTER() function returns the quarter of the year of a given date.

This function accepts one argument – the date to extract the quarter from.

Read more

MySQL has a PERIOD_DIFF() function that enables you to find the difference between two periods. The periods are provided as two separate arguments, and they should in the format YYMM or YYYYMM.

Read more

MySQL has a PERIOD_ADD() function that allows you to add a number of months to a given period. It returns a value in the format YYYYMM.

This article provides examples to demonstrate how it works.

Read more

In MySQL, the MONTHNAME() function returns the month name from a date.

For example, if you provide a date of 2021-12-07, the MONTHNAME() function will return December.

Read more

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

In this context, the month is a value between 1 and 12 (or 0 for dates with a zero month part).

For example, if you provide a date of 2018-10-07, the MONTH() function will return 10.

Read more

When using MySQL, you can use the MAKETIME() function to return a time from the various time parts.

In other words, you provide three arguments; the hour, the minutes, and the seconds. The MAKETIME() function will then return the time value based on those two arguments.

Read more

When using MySQL, you can use the MAKEDATE() function to return a date from the year and day-of-year parts.

In other words, you provide two arguments; one being the year, and the other being the day-of-year. The MAKEDATE() function will then return the date value based on those two arguments.

Read more