Collections:
TIME_TO_SEC() - Converting Time to Seconds
How to convert a time value into seconds using the TIME_TO_SEC() function?
✍: FYIcenter.com
TIME_TO_SEC(time) is a MySQL built-in function that converts a time value into seconds using the (s + 60*m + 60*60*h) formula. For example:
SELECT TIME_TO_SEC(NOW(3)), NOW(); -- +---------------------+---------------------+ -- | TIME_TO_SEC(NOW(3)) | NOW() | -- +---------------------+---------------------+ -- | 75921 | 2023-11-15 21:05:21 | -- +---------------------+---------------------+ 1 row in set (0.00 sec) SELECT TIME_TO_SEC('21:05:21'), 21+60*05+60*60*21; -- +-------------------------+-------------------+ -- | TIME_TO_SEC('21:05:21') | 21+60*05+60*60*21 | -- +-------------------------+-------------------+ -- | 75921 | 75921 | -- +-------------------------+-------------------+ SELECT TIME_TO_SEC('100:00:00'); -- +--------------------------+ -- | TIME_TO_SEC('100:00:00') | -- +--------------------------+ -- | 360000 | -- +--------------------------+
Reference information of the TIME_TO_SEC() function:
TIME_TO_SEC(time): int converts a time value into seconds using the (s + 60*m + 60*60*h) formula. Arguments, return value and availability: time: Required. The time value to be converted. int: Return value. The number of seconds from the given time. Available since MySQL 4.
⇒ TO_DAYS() - Converting Date to Days
⇐ TIME_FORMAT() - Formatting Time
2023-11-17, 245🔥, 0💬
Popular Posts:
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...