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, 256🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...