When working with MySQL, you can use the TIME() function to extract the time part from a time or datetime value.
The way it works is, you pass the time/datetime expression in as an argument, and TIME() will return the time part.
Tag: date functions
SUBTIME() Examples – MySQL
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.
STR_TO_DATE() Examples – MySQL
The MySQL STR_TO_DATE() function allows you to build a date value from the various date parts.
When using this function, you provide a string of the various date parts, and a second argument that specifies the format that the date is provided in.
SEC_TO_TIME() Examples – MySQL
When using MySQL, you can use the SEC_TO_TIME() function to build a time value based on a given number of seconds. Basically, you provide the number of seconds as an argument, and it will convert that to a time value.
Here’s how it works.
QUARTER() Examples – MySQL
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.
PERIOD_DIFF() Examples – MySQL
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.
PERIOD_ADD() Examples – MySQL
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
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
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
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.