Collections:
SEC_TO_TIME() - Converting Seconds to Time
How to convert seconds to a time value using the SEC_TO_TIME() function?
✍: FYIcenter.com
SEC_TO_TIME(seconds) is a MySQL built-in function that
converts seconds to a time value.
For example:
SELECT SEC_TO_TIME(2378), SEC_TO_TIME(2378+1), SEC_TO_TIME(2378)+1; -- +-------------------+---------------------+---------------------+ -- | SEC_TO_TIME(2378) | SEC_TO_TIME(2378+1) | SEC_TO_TIME(2378)+1 | -- +-------------------+---------------------+---------------------+ -- | 00:39:38 | 00:39:39 | 3939 | -- +-------------------+---------------------+---------------------+
Reference information of the SEC_TO_TIME() function:
SEC_TO_TIME(seconds): tm Returns the seconds argument, converted to hours, minutes, and seconds, as a TIME value. The range of the result is constrained to that of the TIME data type. Arguments, return value and availability: seconds: Required. The seconds to be converted to time from. tm: Return value. The converted time. Available since MySQL 4.
⇒ STR_TO_DATE() - Parsing String to Datetime
2023-11-17, 1726🔥, 0💬
Popular Posts:
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function?...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Happens to the Current Transaction If a START TRANSACTION Is Executed in MySQL? If you are in a...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What Are the Basic Features of a Trigger in SQL Server? Since a SQL Server trigger is a really an ev...