Collections:
HOUR() - Hours of Time
How to extract the hours from a given time using the HOUR() function?
✍: FYIcenter.com
HOUR(time) is a MySQL built-in function that returns the hour value from a given time. For example:
SELECT HOUR(NOW()), NOW(); -- +-------------+---------------------+ -- | HOUR(NOW()) | NOW() | -- +-------------+---------------------+ -- | 22 | 2023-11-14 22:59:16 | -- +-------------+---------------------+
Reference information of the HOUR() function:
HOUR(time): int Returns the hour for time. The range of the return value is 0 to 23 for time-of-day values. Arguments, return value and availability: time: Required. The time to extract the hour from. int: Return value. The hour value. Available since MySQL 4.
Related MySQL functions:
⇒ LAST_DAY() - Last Day of Month
⇐ GET_FORMAT() - Standard Datetime Formats
2023-11-17, 243🔥, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
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 Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...