Collections:
SECOND() - Seconds of Time
How to extract the seconds from a given time using the SECOND() function?
✍: FYIcenter.com
SECOND(time) is a MySQL built-in function that returns the second value from a given time. For example:
SELECT SECOND(NOW()), NOW(); -- +---------------+---------------------+ -- | SECOND(NOW()) | NOW() | -- +---------------+---------------------+ -- | 13 | 2023-11-14 23:08:13 | -- +---------------+---------------------+
Reference information of the SECOND() function:
SECOND(time): int Returns the seconds for time, in the range 0 to 59. Arguments, return value and availability: time: Required. The time to extract the second from. int: Return value. The second value. Available since MySQL 4.
Related MySQL functions:
⇒ SEC_TO_TIME() - Converting Seconds to Time
2023-11-17, 245🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...