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, 257🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...