Ian – Page 388

PERIOD_ADD() Examples – MySQL

January 28, 2021June 29, 2018 by Ian

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.

MONTHNAME() Examples – MySQL

October 17, 2021June 28, 2018 by Ian

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.

MONTH() Examples – MySQL

January 28, 2021June 28, 2018 by Ian

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.

MAKETIME() Examples – MySQL

January 28, 2021June 28, 2018 by Ian

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.

MAKEDATE() Examples – MySQL

January 28, 2021June 28, 2018 by Ian

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.