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, 1342🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...