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, 260🔥, 0💬
Popular Posts:
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...