Collections:
TIME() - Extracting Time
How to obtain the time from a datetime using the TIME() function?
✍: FYIcenter.com
TIME(dt) is a MySQL built-in function that
returns the time from a datetime.
For example:
SELECT TIME('2023-12-31 01:02:03');
-- +-----------------------------+
-- | TIME('2023-12-31 01:02:03') |
-- +-----------------------------+
-- | 01:02:03 |
-- +-----------------------------+
SELECT TIME(NOW()), TIME(NOW(6));
-- +-------------+-----------------+
-- | TIME(NOW()) | TIME(NOW(6)) |
-- +-------------+-----------------+
-- | 15:00:48 | 15:00:48.187593 |
-- +-------------+-----------------+
Reference information of the TIME() function:
TIME(expr): tm Extracts the time part of the time or datetime expression expr and returns it as a string. Arguments, return value and availability: expr: Required. The datetime to extract time from. tm: Return value. The extracted time. Available since MySQL 4.
Related MySQL functions:
⇒ TIMEDIFF() - Difference of Two Timestamps
⇐ SYSDATE() - Current Timestamp
2023-11-17, 2058🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Get the Definition of a View Out of the SQL Server in SQL Server? If you want get the definit...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...