Skip to content
DBCode

MINUTE_SECOND

Example

Section titled “Example”
SELECT MINUTE_SECOND('2022-12-17 15:35:42');

Output

Section titled “Output”
353000

Explanation

Section titled “Explanation”

MINUTE_SECOND is a MySQL function that returns the minutes and seconds of a datetime as an integer in the format MMSS00 (minutes, seconds, and some zeroes). The above example returns 353000, indicating 35 minutes and 30 seconds from the original datetime value.