Collections:
MAKETIME() - Making Time from Components
How to compose a time from hour, minute and second components using the MAKETIME() function?
✍: FYIcenter.com
MAKETIME(hour, minute, second) is a MySQL built-in function that
composes a time from hour, minute and second components.
For example:
SELECT MAKETIME(12,15,30), MAKETIME(12,15,30.123456); -- +--------------------+---------------------------+ -- | MAKETIME(12,15,30) | MAKETIME(12,15,30.123456) | -- +--------------------+---------------------------+ -- | 12:15:30 | 12:15:30.123456 | -- +--------------------+---------------------------+
Reference information of the MAKETIME() function:
MAKETIME(hour, minute, second): tm Returns a time value calculated from the hour, minute, and second arguments. The second argument can have a fractional part. Arguments, return value and availability: hour: Required. The hour component of time, 0 to 23. minute: Required. The hour component of time, 0 to 59. second: Required. The second component of time, 0 to 59, with fraction. tm: Return value. The calculated time. Available since MySQL 4.
⇒ MICROSECOND() - Microseconds of Time
⇐ MAKEDATE() - Making Date from Days
2023-11-17, 2223🔥, 0💬
Popular Posts:
Where to find reference information and tutorials on MySQL database functions? I want to know how to...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......