date functions – Page 24

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.

LOCALTIME Examples – MySQL

January 28, 2021June 27, 2018 by Ian

The MySQL LOCALTIME function is a synonym for the NOW() function. It returns the current date and time.

The value is returned in ‘YYYY-MM-DD HH:MM:SS’ or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context.

LOCALTIMESTAMP Examples – MySQL

January 28, 2021June 27, 2018 by Ian

The MySQL LOCALTIMESTAMP function is a synonym for the NOW() function. It returns the current date and time.

The value is returned in ‘YYYY-MM-DD HH:MM:SS’ or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context.

LAST_DAY() Examples – MySQL

January 28, 2021June 27, 2018 by Ian

When using MySQL, you can use the LAST_DAY() function to return the last day of a given month.

You can provide the current date, or you can provide another specified date (for example, a date from a column in a database), and LAST_DAY() will return the last day of the month for that date.

MICROSECOND() Example – MySQL

January 28, 2021June 27, 2018 by Ian

The MySQL MICROSECOND() function is used to return the microsecond component from a time value.

The return value for this function is in the range 0 to 999999. Below are examples to demonstrate.

SECOND() Example – MySQL

January 28, 2021June 27, 2018 by Ian

The MySQL SECOND() function is used to return the second component from a time value.

The return value for this function is in the range 0 to 59. Below are examples to demonstrate.

MINUTE() Examples – MySQL

January 28, 2021June 27, 2018 by Ian

The MySQL MINUTE() function is used to return the minute component from a time value.

The return value for this function is in the range 0 to 59. Below are examples to demonstrate.

HOUR() Examples – MySQL

January 28, 2021June 27, 2018 by Ian

The MySQL HOUR() function is used to return the hour component from a time value.

The return value for a time-of-day value will be between 0 and 23, however the range returned by this function could be much larger, due to the fact that a time data type isn’t limited to just a time of day (it can also be used to represent elapsed time or a time interval between two events). This means that the returned value could be greater than 24 hours or even a negative value.

GET_FORMAT() Examples – MySQL

January 28, 2021June 26, 2018 by Ian

In MySQL, you can use the GET_FORMAT() function to return a format string for the provided arguments. This can be useful when you need to provide a format string to another function, such as DATE_FORMAT() or STR_TO_DATE().