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, 258🔥, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...